ADO.NET Provider for Parquet

Build 26.0.9655

TestConnectionBehavior

Specifies the behavior of the test connection operation.

Possible Values

READ_FILE, LIST_FILES, NO_OPERATION, AUTHENTICATE, LIST_OR_READ_FILES

Data Type

string

Default Value

"AUTHENTICATE"

Remarks

Changes how the provider responds to a test connection operation based on the integration scenario.

LIST_OR_READ_FILES

List and read files from the storage source until at least one is parsed. Fails if none of the files can be parsed (are invalid). Succeeds even if the directory contains no Parquet files since this provider supports creating files. Note: this mode will not read files in sub-directories. This is the most flexible option and works with both directory and file URIs.

READ_FILE

Validates that the URI points to a readable Parquet file. The URI must point to an existing Parquet file, not a directory. This behavior will fail if the file does not exist or contains invalid Parquet content.

LIST_FILES

Validates that the URI points to a directory and lists its contents. Succeeds even if the directory contains no Parquet files since this provider supports creating files.

NO_OPERATION

Performs basic URI validation without accessing files or verifying their existence. This is useful for quickly validating configuration without network or file system operations.

AUTHENTICATE

Validates connection credentials and URI accessibility. For cloud storage, this verifies authentication. For local files, this checks URI format and basic accessibility.

Notes

  • The provider supports creating new files during write operations. This means that empty or non-existing directories do not cause connection test failures for most behaviors, as the provider assumes you may intend to create new files in those locations.

Behavior by URI examples

URI Type NO_OPERATION READ_FILE LIST_FILES LIST_OR_READ_FILES AUTHENTICATE
Directory with parquet files Success Failure: URI must point to an existing file Success Success Success
Empty directory Success Failure: URI must point to an existing file Success Success Success
Non-existing directory Success Failure: URI must point to an existing file Success Success Success
Valid parquet file Success Success Failure: URI must point to an existing directory Success Success
Non-existing file Success Failure: URI must point to an existing file Failure: URI must point to an existing directory Failure: URI must point to valid file or directory Success
Invalid parquet content Success Failure: Parsing error Failure: URI must point to an existing directory Failure: Parsing error Success
Cloud storage, invalid credentials Success Failure: Authentication failed Failure: Authentication failed Failure: Authentication failed Failure: Authentication failed

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655