Hi,
I created a Table chart and saved it as dashboard by using a database Table which comes from Google Big Query. The table in Google Big Query has got more than 5000 records approx. 60,000 rows.
I tried to setup Scheduled SFTP Server delivery in Looker to see if I can get all the 60,000 records in the SFTP server in the form of CSV file. However, I am just getting only 5000 records in the SFTP server.
Looker Documentation says “SFTP server is a good method to use when data or visualization is too large”
https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-new-dashboards#sftp
Do anyone tried to Schedule delivery SFTP Server to deliver more than 5000 records to SFTP server? Any help please?
Any other delivery method that you would suggest apart from Email and SFTP like webhook, Amazon S3, Admin-enabled integrations which would deliver more 5000 records through scheduling?
Solved! Go to Solution.
Hello,
You should check this option here: limit ALL Results and you will get all your records in the export 😉
I’m exporting csv with 100.000 rows without issue like this!