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

Parameters (Connect-GoogleBigQuery Cmdlet)

CData Cmdlets for Google BigQuery 2019 - Build 19.0.7354

The following is the full list of the parameters of the cmdlet with short descriptions. Click the links for further details.

Parameter Required Description
AllowAggregateParameters    Allows raw aggregates to be used in parameters when QueryPassthrough is enabled. 
AllowLargeResultSets    Whether or not to allow large datasets to be stored in temporary tables for large datasets. 
AllowUpdatesWithoutKey    Whether or not to allow update without primary keys. 
AuditLimit    The maximum number of rows which will be stored within an audit table. 
AuditMode    What provider actions should be recorded to audit tables. 
AutoCache    Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider . 
BigQueryOptions    A comma separated list of Google BigQuery options. 
CacheConnection    The connection string for the cache database. This property is always used in conjunction with CacheProvider . Setting both properties will override the value set for CacheLocation for caching data. 
CacheLocation    Specifies the path to the cache when caching to a file. 
CacheMetadata    This property determines whether or not to cache the table metadata to a file store. 
CacheProvider    The name of the provider to be used to cache data. 
CacheTolerance    The tolerance for stale data in the cache specified in seconds when using AutoCache . 
DatasetId    The DatasetId of the dataset you wish to connect to and view tables of. 
DestinationTable    DestinationTable is entered in the format DestinationProjectId:DestinationDataSet.TableName. Setting DestinationTable allows the query to return very large result sets (more than 128mb of result data) to a permanent destination table. 
FilterColumns    Please set `AllowUpdatesWithoutKey` to true before you could use this property. 
FirewallPassword    A password used to authenticate to a proxy-based firewall. 
FirewallPort    The TCP port for a proxy-based firewall. 
FirewallServer    The name or IP address of a proxy-based firewall. 
FirewallType    The protocol used by a proxy-based firewall. 
FirewallUser    The user name to use to authenticate with a proxy-based firewall. 
GenerateSchemaFiles    Indicates the user preference as to when schemas should be generated and saved. 
InitiateOAuth    Set this property to initiate the process to obtain or refresh the OAuth access token when you connect. 
Location    A path to the directory that contains the schema files defining tables, views, and stored procedures. 
Logfile    A path to the log file. 
MaximumBillingTier    The MaximumBillingTier is a positive integer that serves as a multiplier of the basic price per TB. For example, if you set MaximumBillingTier to 2, the maximum cost for that query will be 2x basic price per TB. 
MaximumBytesBilled    Limits how many bytes BigQuery will allow a job to consume before it is cancelled. 
MaxLogFileCount    A string specifying the maximum file count of log files. When the limit is hit, a new log is created in the same folder with the date and time appended to the end and the oldest log file will be deleted. 
MaxLogFileSize    A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. 
MaxRows    Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. 
OAuthAccessToken  True  The access token for connecting using OAuth. 
OAuthClientId    The client ID assigned when you register your application with an OAuth authorization server. 
OAuthClientSecret    The client secret assigned when you register your application with an OAuth authorization server. 
OAuthJWTCert    The JWT Certificate store. 
OAuthJWTCertPassword    The password for the OAuth JWT certificate. 
OAuthJWTCertSubject    The subject of the OAuth JWT certificate. 
OAuthJWTCertType    The type of key store containing the JWT Certificate. 
OAuthJWTIssuer    The issuer of the Java Web Token. 
OAuthJWTSubject    The user subject for which the application is requesting delegated access. 
OAuthRefreshToken    The OAuth refresh token for the corresponding OAuth access token. 
OAuthSettingsLocation    The location of the settings file where OAuth values are saved when InitiateOAuth is set to GETANDREFRESH or REFRESH. Alternatively, this can be held in memory by specifying a value starting with memory://. 
OAuthVerifier    The verifier code returned from the OAuth authorization URL. 
Offline    Use offline mode to get the data from the cache instead of the live source. 
Other    These hidden properties are used only in specific use cases. 
PageSize    The number of results to return per page from Google BigQuery. 
PollingInterval    This determines how long to wait in seconds, between checks to see if a job has completed. 
ProjectId  True  The ProjectId of the billing project for executing jobs. 
ProxyAuthScheme    The authentication type to use to authenticate to the ProxyServer proxy. 
ProxyAutoDetect    This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings. 
ProxyExceptions    A semicolon separated list of hosts or IPs that are exempt from connecting through the ProxyServer . 
ProxyPassword    A password to be used to authenticate to the ProxyServer proxy. 
ProxyPort    The TCP port the ProxyServer proxy is running on. 
ProxyServer    The hostname or IP address of a proxy to route HTTP traffic through. 
ProxySSLType    The SSL type to use when connecting to the ProxyServer proxy. 
ProxyUser    A user name to be used to authenticate to the ProxyServer proxy. 
PseudoColumns    This property indicates whether or not to include pseudo columns as columns to the table. 
QueryPassthrough    This option passes the query to Google BigQuery as-is. 
Readonly    You can use this property to enforce read-only access to Google BigQuery from the provider. 
RefreshViewSchemas    Allows the provider to determine up-to-date view schemas automatically. 
RTK    The runtime key used for licensing. 
SSLServerCert    The certificate to be accepted from the server when connecting using TLS/SSL. 
StoragePageSize    Specifies the page size to use for Storage API queries. 
StorageThreshold    The minimum number of rows a query must return to invoke the Storage API. 
Tables    This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC. 
TempTableDataset    The prefix of the dataset that will contain temporary tables when executing queries with large result sets. 
TempTableExpirationTime    Time, in seconds until the temporary table expires. Set to 0 to have the table never expire. 
Timeout    The value in seconds until the timeout error is thrown, canceling the operation. 
UseLegacySQL    Specifies whether to use BigQuery's legacy SQL dialect for this query. By default, Standard SQL will be used. 
UseQueryCache    Specifies whether to use Google BigQuery's built-in query cache. 
UseStorageApi    Specifies whether to use BigQuery's Storage API for bulk data reads. 
UseStreamingInserts    Specifies whether to use streaming or DML statements when inserting data. By default, streaming inserts are used. 
Verbosity    The verbosity level that determines the amount of detail included in the log file. 
Views    Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC. 

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