Skip to main content

Data Query FAQs

Zuora

Data Query FAQs

  1. Q: Does Data Query support the currency conversion?

    A: No, not yet.

  2. Q: What are some common SQL errors that I should look out for?

    A:

    • Error: Column region_c cannot be resolved

      Solution: You are missing a reference to the table that includes region__c. Select or join from that table in your query and try again.

    • Error: Query exceeded the maximum time limit of 3600.00s

      Solution: This error is thrown when you reach one of the system limitations in Data Query. Queries running for longer than 1 hour will be canceled. Your query might be running for a long time for many reasons: you are doing complex JOINs across many tables without filters in your WHERE clause, or you are doing complex aggregate functions in your query, or you are running many SELECT clauses in one query, and so on. Try to address one or several of these issues to improve your query performance.

    • Error: Table owl.data.acccount does not exist

      Solution: The table you are trying to access either does not exist in your tenant or you have a spelling error in your query. Run SHOW TABLES to confirm that you have that table in your tenant.

  3. Q: Can I submit a ZOQL query to Data Query?
    A: No. Only SQL queries are supported. You must convert ZOQL statements to SQL statements before submitting data queries. See ZOQL to SQL conversions for more information.