Variable | Type | Description | Default Value |
|---|---|---|---|
include_relationships | String | Flag indicating whether the agent should retrieve metadata about relationships between tables (True) or not (False). | False |
results_limit | Integer | Maximum number of rows that the SQLGenerationAgent will return by including a LIMIT clause in the SQL query. | 100 |
catalog_source | String | CDGC catalog source used to retrieve metadata. | - |
retry_number | Integer | Maximum number of times the agent will retry generating and validating the SQL query before stopping. | 3 |
database_type | String | Type of database, for example, Snowflake, used to determine the correct SQL syntax and execution environment. | Snowflake |
api_url | String | URL of the IDMC API gateway to retrieve metadata and interact with the CDGC service. Use the following URL: https://idmc-api.<cloud provider>-<region>.informaticacloud.com | - |
host_name_login | String | Base URL of the POD to log in to the IDMC organization. Use the following URL: https://<cloud provider>-<region>.informaticacloud.com | - |