Generate Schema FilesCData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354
Indicates the user preference as to when schemas should be generated and saved.
This property outputs schemas to .rsd files in the path specified by Location.
Available settings are the following:
- Never: A schema file will never be generated.
- OnUse: A schema file will be generated the first time a table is referenced, provided the schema file for the table does not already exist.
- OnStart: A schema file will be generated at connection time for any tables that do not currently have a schema file.
Generate Schemas with SQL
When you set GenerateSchemaFiles to OnUse, the add-in generates schemas as you execute SELECT queries. Schemas are generated for each table referenced in the query.
Generate Schemas on Connection
Another way to use this property is to obtain schemas for every table in your database when you connect. To do so, set GenerateSchemaFiles to OnStart and connect.