Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
As per the document: https://academy.dataiku.com/integration-with-sql-databases-1/500814 , its advising to use Administration option but in my DSS i dont find such option. Please find the screenshot. Am i missing something here (or) any other tools/command line to be used to get the admin access?
Note: i am in the trail version and it has 7 days left before end of trial
Appreciate your help to complete the course.
Hi @ercsaravanan as you suspected in the trial version (and in Dataiku Online in general) there is no administration option. However, you can utilize the Launchpad in your instance to connect your data.
You bring up a fair point however in terms of the Academy tutorial not being clear in that regard. So we will flag this tutorial for doc improvement. Thanks for surfacing this here and I hope this helps!
As per : https://knowledge.dataiku.com/latest/kb/dku-online/data-connection.html#how-to-connect-to-your-data-... , its not allowing the localhost connection for Postgresql. It requires public server.
As per https://academy.dataiku.com/integration-with-sql-databases-1/500809, we can use localhost.
Whats the best way to connect SQL (Postgresql from local) and test the use case from DSS for the trail version users?
Indeed you won't be able to connect to localhost from Dataiku online.
You need to use Public IP or DNS name where you have your Postgres instance.
If you installed Postgres on your local machine, you would need to expose Postgres via public IP on a home network which would be quite complex.
It may be easier to use a free tier service like ngork to create a tunnel to your local machine. See https://ngrok.com/ After you install the client and establish the tunnel, you can connect to the ngork provided URL/port to connect to your local instance.
Or install Postgres on AWS/Azure/GCP etc.
it is actually a quite confusing. on the other hand, snowflakes account is not useful for further progress with the course. For example, in Dataiku and SQL module, hands-on sync recipe requires postgres which we cannot establish a connection using the local host. Please update the material with clear steps