SQL Database Query

Directly launches queries on an SQL database to extract targeted information.

Detailed Explanation

1. Name:

   • This field allows you to assign a specific name to your SQL database connection, helping you identify it within your project.

   • Example: You might name it "Employee Database" if the SQL database contains employee-related information.

2. URI:

   • This field is for specifying the database connection URI. The format typically follows these examples:

     • For MySQL: mysql://user:password@localhost:3306/mydb

     • For PostgreSQL: postgres://user:password@localhost:5432/mydb

   • Example: If your database is hosted on your local machine, you might enter:

     Copymysql://username:password@localhost:3306/mydatabase

3. SQL Query:

   • This field allows you to specify the SQL query you want to execute. Only SELECT queries are supported in this connector.

   • Example: If you want to retrieve all records from a table named employees, you would enter:

     CopySELECT * FROM employees;

4. Chunk Size:

   • This field specifies the number of tokens or characters in each chunk of data. The default value is set to 1024, but you can adjust it based on your needs. This can be particularly useful when dealing with large result sets.

   • Example: If you expect a large volume of data, you might set the chunk size to 512 for easier processing.

5. Cost Information:

   • This section provides details about the cost associated with importing words from the specified SQL database query.

   • Example: If it states "Cost per words: 0.035 tokens" and "Remaining words: 1279900685 Words," this indicates how many tokens will be charged for each word processed and the total number of words remaining for processing.