Kedro is an open-sourced Python framework for creating maintainable and modular data science code.

Kedro

Hi all! Has anyone used Kedro to load data from Amazon Redshift?
I tried using the SQLDataSet, but getting credentials issues since the creds I passed are not SQLAlchemy connection string. Would be helpful to know what worked for anyone.

<@U03S12LHNNQ>, do you know if Redshift is planned to be supported by Ibis? Using BigQuery with the Ibis Kedro Dataset provided a superb experience.

Let me ask if anybody has a surer answer, but it looks like you could use the Postgres backend, based on some issues I found like <https://github.com/ibis-project/ibis/issues/3889|https://github.com/ibis-project/ibis/issues/3889> (the actual issue reported there _may_ have gotten resolved in newer Ibis backends, but would need to confirm; in any case, may not affect you).

&gt; Using BigQuery with the Ibis Kedro Dataset provided a superb experience.
&gt; 
Also, great to hear! :heart:

Looking through some year-old messages

&gt; It's not "officially" supported because redshift is based on a prehistoric version of postgres - 8.0
&gt; 
But we do occasionally get issues filed by people using Redshift with a Postgres backend.

Thanks Deepyaman! I tried the postgres way using SQLDataSet and it worked