Snowflake
Last updated
Was this helpful?
Last updated
Was this helpful?
A cloud-based data platform offers a scalable, secure, and high-performance relational database that offers online services and minimal management.
Means for Lumi to connect to the client to implement the services required
The following are limitations that can be set to fine tune the agents' actions:
These properties are the essential source system connection properties that all queries are directed towards.
* Required parameters
Provided user must have the following:
Generate a new ROLE and grant privileges:
GRANT USAGE ON DATABASE <database> TO ROLE <role>
GRANT USAGE ON SCHEMA <database.schema> TO ROLE <role>
Grant SELECT to all tables via GRANT SELECT ON ALL TABLES IN SCHEMA <database.schema> TO ROLE <role>
When applicable, grant the role to the generated user
For configurations:
Ensure the server is allowing connections from the Lumi gateway or server via the firewall
If case sensitivity is required and other special characters, utilize double quotes for database name; ex. "New_database"
Ensure the firewall settings allow for a connection to the database
Ensure the username, password, and database values are explicitly provided
Valid Examples
Invalid Examples
Valid Examples
Invalid Examples
Valid Examples
Invalid Examples