0002964: BigQuery SQL - Tickets.CaseTalk

ID	Project	Category	View Status	Date Submitted	Last Update

0002964	CaseTalk Modeler	Generation (SQL, XML, etc)	public	2021-04-19 15:21	2024-03-13 09:36

Reporter	BCP Software	Assigned To	BCP Software
Priority	normal	Severity	feature	Reproducibility	N/A
Status	assigned	Resolution	open
Target Version	13.4

Summary	0002964: BigQuery SQL
Description	Support BigQuery SQL, which should be standard SQL2011 compatible, but we need to check and add the list of supported datatypes. https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types
Tags	No tags attached.

CaseTalk Edition	unknown

BCP Software 2022-01-11 08:54 administrator ~0004368	Support for Description, and Cluster index (instead of primary key?) `CREATE TABLE mydataset.myclusteredtable ( customer_id STRING, transaction_amount NUMERIC ) CLUSTER BY customer_id OPTIONS ( description="a table clustered by customer_id" )`

BCP Software 2022-01-11 08:56 administrator ~0004369 Last edited: 2022-01-11 08:56	Even comes with `View` support. BigQuery SQL DDL

Date Modified	Username	Field	Change
2021-04-19 15:21	BCP Software	New Issue
2021-04-19 15:21	BCP Software	Status	new => assigned
2021-04-19 15:21	BCP Software	Assigned To	=> BCP Software
2022-01-11 08:54	BCP Software	Note Added: 0004368
2022-01-11 08:56	BCP Software	Note Added: 0004369
2022-01-11 08:56	BCP Software	Note Edited: 0004369
2023-10-25 11:40	BCP Software	Target Version	13.0.1 => 13.3
2024-03-13 09:36	BCP Software	Target Version	13.3 => 13.4