Using the Direct Query Method

Use the Direct Query method to work with remote data in real time, rather than importing a local copy. As you define filters, aggregate fields, or join tables, the connector executes the underlying queries to Google Sheets. Direct Query can be used when you cannot import data due to a large data set that may slow Google Sheets, or in the event that the data is actively changing and needs real-time updates.

Direct Query Limit

The Direct Query method is limited by the DirectQueryLimit connection property. If all of the following are true, the limit is replaced from the query to the settings in DirectQueryLimit.

• The QueryPassthrough=false
• The query is a SELECT
• There is a LIMIT clause or equivalent (like TOP)
• The value of the LIMIT is greater than allowed by DirectQueryLimit settings