I have a dashboard which sources its data from three CSV files exported from a legacy system. So every week I have to go download those files and then upload them into Looker Studio by editing the data source connection and replacing the CSV file connected to the data set with the new one.
I want to delegate this job to one of my team, and have given her Edit access to the data source as per the instructions at:
Solved! Go to Solution.
@PhilSt
What we usually do in Bigglo in such cases is fully automating the process using Cloud Storage and BigQuery.
You can quickly set-up a bucket on cloud and use BQ data transfer which will automatically replace/append new data from csv into BigQuery Table.
https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv
Theh benefit of this solution is no manual work will be needed.
You can go even more fancy and automate data ingestion from your system to Cloud Storage with some simple Cloud function.
@PhilSt
What we usually do in Bigglo in such cases is fully automating the process using Cloud Storage and BigQuery.
You can quickly set-up a bucket on cloud and use BQ data transfer which will automatically replace/append new data from csv into BigQuery Table.
https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv
Theh benefit of this solution is no manual work will be needed.
You can go even more fancy and automate data ingestion from your system to Cloud Storage with some simple Cloud function.
User | Count |
---|---|
9 | |
7 | |
2 | |
1 | |
1 |