How often is readily found simply by the schedules that are run to update the extracts. Another way would be to have your Redshift DBA query their logs
I don't know the answer right off so let me look. I also moved this to the Server forum so others can chime in as there's some folks who know much more than I
The more I think about it the more I think you should get your data from the Redshift DBA. Even a text dump should allow you do connect with Desktop or Excel to analyze the data.
I just updated my report that may be helpful regarding data sources, workbooks, and schedules:
My datasource_refresh_properties table is empty just like yours so...
Also, I would like to add another point. You have done the join below
LEFT JOIN "public"."data_connections" "data_connections" ON ("datasources"."id" = "data_connections"."owner_id" AND "data_connections"."owner_type" = 'Datasource'
However, datasource Id needs to joined with datasource id in data connection. when i changed that, it looks good
LEFT JOIN "public"."data_connections" "data_connections" ON ("datasources"."id" = "data_connections"."datasource_id" AND "data_connections"."owner_type" = 'Datasource'
For Datasources those two numbers are the same*:
Those numbers will be different for Workbooks. For SQL code consistency I used the same logic for both Custom SQL data sources in the report.
FYI for others looking at this: owner_id does not mean user_id. It means "for a given data connection what is the object ID, a Workbook ID or a Datasource ID?". owner_type is either Workbook or Datasource so the owner_id will point to the appropriate table id in public.workbooks or public.datasources.
The public.data_connections table does have the datasource_id field for owner_type = "Workbook". That id value can be used to JOIN to the public.datasources table. If you look at the public.datasources table it has the field parent_workbook_id. which could be used to JOIN to the public.workbooks table. That parent_workbook_id field could also be used to JOIN to the public.data_connections.owner_id field if owner_type = "Workbook". So, as you can see, there are a couple of ways to get from one table to another, which is nice.
*The workbook I created was in Nov. 2014 which was version 8.1 for us. I checked the tables in a separate SQL editor and referenced the Admin guide and the above logic is still valid for the version we're on, 9.3.4.
Thanks for explaining Toby Erkson. I did get mixed up with users to the owner. Is there anyway that you are aware of in redshift, to identify connections from tableau. because as of the connection, i m inputing the credentials of my redshift cluster. How can we distinguish between the one from tableau or my other connections.
I'm not familiar with redshift so I do not know