Icon

05_​Austin bike sharing with Google BigQuery

Austin Bike-sharing with Google BigQuery
Google Authentication Austin weather Data load on Google BigQuery Austin Bikeshare custom query This workflow connects to Google BigQuery in order to retrieve public available data. After manipulation and visualiation, data areuploaded as a BigQuery personal schema. Connect to BigQuery schemaSelect tableand fieldsGroup by dayQuery the DBFilter outsome rowsProvide your serviceaccount ID and the P12 keyRead local fileRead dateConvert string todate formatJoin dataCreate table on BigQueryUpload data Google BigQueryConnector DB Table Selector DB GroupBy DB Reader DB Row Filter Google Authentication(API Key) File Reader Extract Date&TimeFields String to Date&Time Joiner DB Table Creator DB Loader Data manipulation Visualization Google Authentication Austin weather Data load on Google BigQuery Austin Bikeshare custom query This workflow connects to Google BigQuery in order to retrieve public available data. After manipulation and visualiation, data areuploaded as a BigQuery personal schema. Connect to BigQuery schemaSelect tableand fieldsGroup by dayQuery the DBFilter outsome rowsProvide your serviceaccount ID and the P12 keyRead local fileRead dateConvert string todate formatJoin dataCreate table on BigQueryUpload data Google BigQueryConnector DB Table Selector DB GroupBy DB Reader DB Row Filter Google Authentication(API Key) File Reader Extract Date&TimeFields String to Date&Time Joiner DB Table Creator DB Loader Data manipulation Visualization

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Emilio Silvestri
Created at: 2019-12-04
On NodePit since: 2020-03-02
Last update: 2024-04-26
Created with KNIME version: v4.1.1
Tags: Google BigQueryDB querycloud

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!