Connect to Your Data Source
Table of contents
Connect to Data Source
By creating a connection with your data sources, you leverage the capabilities to generate accurately structured SQL with minimal manual effort. Plus, it brings the ability for your team members to safely execute queries directly on the data source. To proceed with adding a data source, you need to explore the add data source section.
Choose the "Advanced" link below the data links for further options. Here, you a choice to save your data sources either on a remote server or in your browser's local storage unit. For optimal outcomes, it's recommended to store the data source on the server.
How to Select Data Source Type
Select the desired data source to connect, for example, PostgreSQL. Then, you get to fill in your connection credentials. Rest assured, your credentials will be stored with advanced encryption for maximum security.
While using a connection URL, ensure that it follows the below illustrated format:
<database_engine>://<username>:<password>@<host>:<port>/<database_name>
For instance, if you operate on a database hosted on AWS RDS, a READ ONLY user is suggested:
postgresql://user:password@my_database.abc123.us-east-1.rds.amazonaws.com:5432/my_database
Confirmation of Data Source Addition
Congratulations! Your data source has successfully been added. SQLAI.ai has encrypted the sensitive connection credentials followed by executing a query to acquire the (only) database schema, such as the table and column names. With this, you can generate SQL, run queries against the data source, as well as share it with your team members.
- Tip: A technical user holds the capability to set up the data source. Using a read only database connection, they can then extend an invitation for non-technical team members to utilize it.