DataConnectionObject

DataConnectionObject[assoc]

represents data given by the details in assoc.

Details and Options

  • DataConnectionObject uses a data connector to retrieve data from a remote storage system handling authentication and data retrieval.
  • Use Import to retrieve data from the linked resource.
  • DataConnectionObject creates a reference to a data source. The source does not need to exist yet.
  • General keys typically found in assoc are:
  • "ConnectionName" name of the connection ("AmazonS3", "Dropbox")
    "Location"connection-specific path or location details
    "Redownload"whether to redownload cache files
    • AmazonS3
  • For "AmazonS3", additional keys of assoc include:
  • "Region"the region where the bucket is located
    "Bucket"the bucket name containing the data
  • Possible forms of "Location" when connecting to an Amazon S3 object include:
  • "key"assigned name
    • AzureBlobStorage
  • For "AzureBlobStorage", additional keys of assoc include:
  • "Account"the account name
    "Container"the container name
  • Possible forms of "Location" when connecting to an Azure blob include:
  • "path"path to the blob
    • Dropbox
  • For "Dropbox", possible forms of "Location" when connecting to data include:
  • "path"path to the file
    • IPFS
  • For "IPFS", possible forms of "Location" when connecting to data include:
  • "cid"IPFS content identifier (CID)
    • Options
  • DataConnectionObject supports the Authentication option.
  • Possible values for Authentication are:
  • Automaticattempt to use saved credentials or give a dialog
    "Dialog"give authentication parameters via a dialog
    SystemCredential["key"]retrieve authentication information from secure storage
    SystemCredentialData[…]stored authentication data
    assocprovide explicit credentials
  • Use the form Authentication :> SystemCredential["key"] or Authentication :> Environment["var"] to delay evaluating securely stored credentials.
  • The following keys are accepted by Authenticationassoc:
  • "AmazonS3"<|"AccountKeyID"…,"AccountSecret"…|>
    "AzureBlobStorage"<|"SASToken"…|>
    • Properties
  • DataConnectionObject[…]["Properties"] returns the list of all available properties of the connection.
  • DataConnectionObject[…][prop] returns the property prop of the connection.
  • Supported properties typically include:
  • "ConnectionName"name of the connection
    "Location"specified path or SQL query
    "Redownload"whether the connection always redownloads
  • When data is retrieved from a connection, it is usually cached in $TemporaryDirectory.

Examples

open allclose all

Basic Examples  (4)

Create a DataConnectionObject to data located on Azure Blob Storage:

Get the format of the data:

Import tabular data from a DataConnectionObject:

Import an image from a DataConnectionObject:

Scope  (9)

Basic Operations  (3)

Import tabular data from a DataConnectionObject:

Get the format of the data:

By default, data is cached in $TemporaryDirectory the first time it is retrieved:

Use "Redownload" True to refresh the cached file:

Amazon S3  (2)

Retrieve data from Amazon S3:

Give credentials to Amazon S3:

Azure Blob Storage  (2)

Retrieve data from Azure Blob Storage:

Give credentials to Azure Blob Storage:

Dropbox  (1)

Retrieve data from your Dropbox account:

IPFS  (1)

Retrieve data from the InterPlanetary File System (IPFS):

Options  (5)

Authentication  (5)

By default, give a dialog or login page:

Show a dialog to give credentials or override saved credentials:

Give explicit credentials as a SystemCredentialData object:

Use credentials stored in SystemCredential:

Give explicit credentials as an association:

Applications  (1)

Analyze a Remote Dataset  (1)

Retrieve data from Azure Blob Storage:

Calculate the mean of the column "numbers" for each expression type:

Generate a pie chart with the average values of "numbers" for each expression type:

Wolfram Research (2025), DataConnectionObject, Wolfram Language function, https://reference.wolfram.com/language/ref/DataConnectionObject.html.

Text

Wolfram Research (2025), DataConnectionObject, Wolfram Language function, https://reference.wolfram.com/language/ref/DataConnectionObject.html.

CMS

Wolfram Language. 2025. "DataConnectionObject." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/DataConnectionObject.html.

APA

Wolfram Language. (2025). DataConnectionObject. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/DataConnectionObject.html

BibTeX

@misc{reference.wolfram_2025_dataconnectionobject, author="Wolfram Research", title="{DataConnectionObject}", year="2025", howpublished="\url{https://reference.wolfram.com/language/ref/DataConnectionObject.html}", note=[Accessed: 22-February-2025 ]}

BibLaTeX

@online{reference.wolfram_2025_dataconnectionobject, organization={Wolfram Research}, title={DataConnectionObject}, year={2025}, url={https://reference.wolfram.com/language/ref/DataConnectionObject.html}, note=[Accessed: 22-February-2025 ]}