DatabaseTestConnectionSchema
Configuration_method is used on the frontend to inform the backend whether to explode parameters or to provide only a sqlalchemy_uri.
Possible values: [sqlalchemy_form, dynamic_form]
sqlalchemy_formA database name to identify this connection.
Possible values: non-empty and <= 250 characters
SQLAlchemy driver to use
SQLAlchemy engine to use
JSON string containing extra configuration elements.
1. The engine_params object gets unpacked into the sqlalchemy.create_engine call, while the metadata_params gets unpacked into the sqlalchemy.MetaData call.
2. The metadata_cache_timeout is a cache timeout setting in seconds for metadata fetch of this database. Specify it as "metadata_cache_timeout": {"schema_cache_timeout": 600, "table_cache_timeout": 600}. If unset, cache will not be enabled for the functionality. A timeout of 0 indicates that the cache never expires.
3. The schemas_allowed_for_file_upload is a comma separated list of schemas that CSVs are allowed to upload to. Specify it as "schemas_allowed_for_file_upload": ["public", "csv_upload"]. If database flavor does not support schema or any schema is allowed to be accessed, just leave the list empty
4. The version field is a string specifying the this db's version. This should be used with Presto DBs so that the syntax is correct
5. The allows_virtual_table_explore field is a boolean specifying whether or not the Explore button in SQL Lab results is shown.
6. The disable_data_preview field is a boolean specifying whether or not data preview queries will be run when fetching table metadata in SQL Lab.7. The disable_drill_to_detail field is a boolean specifying whether or notdrill to detail is disabled for the database.8. The allow_multi_catalog indicates if the database allows changing the default catalog when running queries and creating datasets.
If Presto, all the queries in SQL Lab are going to be executed as the currently logged on user who must have permission to run them.
If Hive and hive.server2.enable.doAs is enabled, will run the queries as service account, but impersonate the currently logged on user via hive.server2.proxy.user property.
JSON string containing additional connection configuration.
This is used to provide connection information for systems like Hive, Presto, and BigQuery, which do not conform to the username:password syntax normally used by SQLAlchemy.
parameters object
DB-specific parameters for configuration
DB-specific parameters for configuration
Optional CA_BUNDLE contents to validate HTTPS requests. Only available on certain database engines.
Refer to the SqlAlchemy docs for more information on how to structure your URI.
Possible values: non-empty and <= 1024 characters
ssh_tunnel objectnullable
SSH Tunnel ID (for updates)
{
"database_name": "string",
"driver": "string",
"engine": "string",
"extra": "string",
"impersonate_user": true,
"masked_encrypted_extra": "string",
"parameters": {},
"server_cert": "string",
"sqlalchemy_uri": "string",
"ssh_tunnel": {
"id": 0,
"password": "string",
"private_key": "string",
"private_key_password": "string",
"server_address": "string",
"server_port": 0,
"username": "string"
}
}