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”
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?
Best answer by anthoView original