Hey all, I'm fairly new to GCP and BigQuery so please be kind. 😥
I've got data coming from an on-premise MS SQL Server that I'd like to use for BI Reports. From my understanding, ideally the BI tool needs to point to a BQ native table to use for reports.
I'm able to automate the daily (batch CSV) data push into Cloud Storage so that the data can be accessed in BigQuery as an External table, but now I'm unsure how the data can flow directly (in an automated fashion) into a BQ native table. What I would like to happen is that every time I push data into Cloud Storage, it can immediately be accessible in BQ as native data so that any BI tool can use the info.
How do I achieve this? Thank you in advance for your help!