IGNORE_FEDSQL_OBJECTS= Data Set Option

Specifies whether to ignore FedSQL objects in a query.

Valid in: DATA and PROC steps (when accessing data that is in an external data source)
Category: Data Access
Default: LIBNAME option value
Data source: Google BigQuery
Note: Support for this option was added in SAS 9.4M9. Support for this option was added to SAS 9.4M8 in December 2025.
See: IGNORE_FEDSQL_OBJECTS= LIBNAME option

Table of Contents

Syntax

IGNORE_FEDSQL_OBJECTS=YES | NO

Required Argument

YES | NO

specifies whether queries should ignore FedSQL objects, such as FedSQL views, DS2 packages, or DS2 threads.

Details

If you enable the IGNORE_FEDSQL_OBJECTS= option, then a query ignores FedSQL objects such as FedSQL views, DS2 packages, or DS2 threads. These objects are typically created by calling PROC FEDSQL or PROC DS2. If you specify this data set option on a FedSQL object, a query immediately returns an empty result.

Last updated: February 3, 2026