CData Cmdlets for Google BigQuery 2019 - Online Help
Questions / Feedback?

GenerateSchemaFiles Parameter (Connect-GoogleBigQuery Cmdlet)

CData Cmdlets for Google BigQuery 2019 - Build 19.0.7354

Indicates the user preference as to when schemas should be generated and saved.

Syntax

Connect-GoogleBigQuery -GenerateSchemaFiles string

Remarks

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.
Note that if you want to regenerate a file, you will first need to delete it.

Generate Schemas with SQL

When you set GenerateSchemaFiles to OnUse, the cmdlet 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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0