ContributionsMost RecentMost LikesSolutionsHow to truncate data with BigQuery Snaps How do I truncate date from a BigQuery Table using the BigQuery Snaps? Is there Upsert Capability for BigQuery Hi, Is there Upsert capability for any of the biqquery snaps? Re: Google Big Query Ok makes sense. Are there other ways/alternatives to truncate and load a bigquery table in snaplogic? Google Big Query Is it possible to truncate a table in bigquery and then run Bulk Load(Streaming). I’ve tested using BigQuery Execute with truncate statement and then link a bulk load(streaming) snap. I get an error message saying invalid input. Its not recognizing the table schema? Redshift to BigQuery Hi, I am looking to move data from Redshift to Google BigQuery. How can I dynamically create a BigQuery Dataset and Table if they do not currently exists? Designing a pipeline to route depending if there is or is not data in an initial query Hi, I am trying to design a pipeline where it initially will pull in a query result set. I am trying to create a route that identifies whether the query result set returned records or did not return records. Any idea on how to design this pipeline?