Conversational Analytics API known limitations

Conversational Analytics API has the following known limitations on the number of data sources, style of visualizations, and size of datasets.

Number of data sources

  • You can query 1 Looker Explore at a time.
  • The Conversational Analytics API limits data queries to 500 GB of bytes processed in BigQuery.

Visualizations

  • These visualization types are fully supported: Line chart, area chart, bar (horizontal, vertical, stacked) chart, scatterplots, pie chart
  • These visualization types are partially supported and may exhibit unexpected behavior: Maps, heatmaps, charts with tooltips

Data size

  • For Looker data sources, the Conversational Analytics API can return a maximum of 5,000 rows per query.
  • The Conversational Analytics API's Python-based reasoning and content retrieval capabilities can accommodate time complexities of up to O(100k) rows.

Query limitations

  • BigQuery's flexible column names feature is not supported.
  • Structs in BigQuery are supported but may sometimes fail.
  • For Looker data sources, the API cannot set the value of a filter-only field that is defined by using the LookML parameter parameter.
  • Using the Conversational Analytics API to connect to a private IP Looker (Google Cloud core) instance using Looker Studio Pro when that Looker (Google Cloud core) instance is inside a VPC Service Controls perimeter is not a supported configuration and does not meet VPC Service Controls compliance requirements.
  • For connections to Looker (Google Cloud core) instances with private IP configurations, Conversational Analytics API does not support Looker (Google Cloud core) instances that are configured to use CMEK or VPC Service Controls.
  • Conversational Analytics API doesn't work well with Looker Studio data sources that have field editing in reports disabled in because this setting prevents Conversational Analytics from creating calculated fields.

Question types limitations

  • Conversational Analytics API supports questions that can be answered by a single visualization, for example:

    • Metric trends over time
    • Breakdown or distribution of a metric by dimension
    • Unique values for one or more dimensions
    • Single metric values
    • The top dimension values by metric
  • Conversational Analytics API doesn't yet support questions that can only be answered with the following types of complicated visualizations:

    • Prediction and forecasting
    • Advanced statistical analysis, including correlation and anomaly detection