BigQuery (Google)

one of the most robust cloud data warehouse solutions, and arguably the first, available on the market today it is a no brainer that we have google bigquery as a target system for dlh io in order to get setup on bigquery we use a sophisticated but elegant solution which aligns with open standards and uses the best pratices prescribed by google, as well as a few that we have learned over hundreds of customer interactions use this section of the documentation to explore basic bigquery setup docid\ e4vawi0kg23gh9ngsamud bigquery case senstivity bigquery dlh io demo video bigquery case sensitivity currently dlh io abides by the case sensitivity of bigquery this means that the dataset/schema and the tables are case senstive when created and populated by dlh io as a future feature we will allow a force case insensitive feature in which case once will need to understand if their source connection has any case sensitivity which could result in an issue as the data is loaded into the target there is potential for case insensitivity to bcome the default standard of dlh io per the bigquery documentation on their lexical structure and syntax there are different uses of case sensitivity in the bigquery platform category case sentitive? notes keywords no bulit in function names no udf names yes table names yes (can turn off) yes, for datasets and tables names; unless the option " is case insensitive " is set to true column name no string values yes string comparisions yes aliases within a query no regular expression matching regex matching is case sensitive by default, unless the regex expression specifies case insensitivity like matching yes if using the is case insensitive option, note that it cannot be used for alter schema only for create schema (ref https //cloud google com/bigquery/docs/reference/standard sql/data definition language#schema option list) https //cloud google com/bigquery/docs/reference/standard sql/data definition language#schema option list this is set when creating the schema as follows set case insensitivity in bigquery create schema mydataset options( is case insensitive=true )