Specifies whether to use INFORMATION_SCHEMA in Google BigQuery to retrieve a list of schemas and tables or views.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Access |
| Default: | YES |
| Data source: | Google BigQuery |
| Note: | Support for this option was added in the August 2019 release of SAS/ACCESS. |
By default, SAS/ACCESS uses INFORMATION_SCHEMA to get metadata for the list of schemas and tables or views, if the names contain a pattern. Names with patterns can be searched using the wildcard characters ‘%’ or ‘_’.
You might want to disable INFORMATION_SCHEMA to improve performance, especially if you are not using patterns to query schema or table names.