Skip to main content
Version: v3.4 print this page

Playground

Large dataset queries​

  1. When querying a dataset in Analytics → Playground, if the underlying file size is very large, use targeted SQL queries (for example, with filters or LIMIT) instead of selecting all rows. Returning a full large result set can exceed synchronous Lambda and API Gateway response size limits and surface as an Internal Server Error.

JDBC Datasource​

  1. Users connecting to the Playground (Athena) via the JDBC Datasource will not be able to access views.

LakeFormation Datasets​

  1. When querying a LakeFormation-Governed dataset after deleting a file, the following error may occur:

    GENERIC_INTERNAL_ERROR: Encountered an exception executed in context[...] with
    message[Encountered an exception executed in
    context[retrieving blocks] with message[Encountered an exception executed in
    context[executing] with message[File not found: Request failed because the
    following file is missing:
    https://<bucketname>.s3.<region>.amazonaws.com/<domain_name>/<dataset_name>/<partition_column>%<partition_value>/<username>_<dataset_id>_<partition_value>_<filename>.
    (Service: AWSLakeFormation; Status Code: 400; Error Code: InvalidInputException;
    Request ID: <request_id>; Proxy: null)]]]