Specifies whether to allow query results larger than the Google BigQuery maximum response size.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Aliases: | ALR= |
| LARGE_RESULTS= | |
| Default: | OFF |
| Data source: | Google BigQuery |
| Note: | Support for this option was added in the April 2021 update for SAS/ACCESS on SAS 9.4M7. Support was extended to SAS 9.4M8 and SAS 9.4M9 with the release of SAS 9.4M9. |
| See: | LARGE_RESULTS_DATASET= LIBNAME option, LARGE_RESULTS_EXPIRATION_TIME= LIBNAME option, LARGE_RESULTS_PROJECT= LIBNAME Statement Option |
Table of Contents
specifies that all query results are written to a temporary stored table, including query results that are smaller than the maximum response size.
specifies that query results that are larger than the maximum response size are written to a temporary stored table.
specifies that query results that are larger than the maximum response size trigger an error in the SAS log, and thus the query fails.
When ALLOW_LARGE_RESULTS= is set to ALWAYS or MUST, query results are written to the data set ID that you specify with the LARGE_RESULTS_DATASET= LIBNAME option. That data set ID is maintained for the amount of time that you specify with the LARGE_RESULTS_EXPIRATION_TIME= LIBNAME option.