Enable Catalog Support
- Last Updated: August 22, 2023
- 1 minute read
- DataDirect Connectors
- ODBC
- Google Bigquery 8.0
- Documentation
Attribute
EnableCatalogSupport (ECS)
Purpose
Determines whether the driver supports specifying values for catalog parameters in metadata calls. Note that catalogs and schemas are equivalent to projects and datasets in Google BigQuery.Valid Values
1 | 0
Behavior
If set to 1, a value can be specified for
the catalog parameter in metadata calls. For example: SQLTables("MyProject","Dataset1","Employee",Null), where MyProject is a catalog, Dataset1 is a schema, and Employee is a
table.
If set to 0, no value can be specified for
the catalog parameter in metadata calls. The values for catalog and schema must be specified
within the schema parameter, seperated by a period. For example: SQLTables(Null,"MyProject.Dataset1","Employee",Null), where MyProject is a catalog, Dataset1 is a schema, and Employee is a
table.
Notes
- The driver can fetch metadata only for:
- The project and dataset the application is connected to.
- The project and dataset specified using the SchemaSet config option.
- When the value for the Enable Catalog Support connection option is changed, the SchemaMap file must be refreshed.
Default
0