DataConnectionObject

DataConnectionObject[assoc]

represents data given by the details in assoc.

Details and Options

DataConnectionObject uses a data connector to make a connection to a remote resource.
DataConnectionObject is typically used as a connection to data in a remote storage system handling authentication and data retrieval.

Use Import to retrieve data from the linked resource.
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:

	Automatic	attempt 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
	assoc	provide explicit credentials

Use the form Authentication :> SystemCredential["key"] or Authentication :> Environment["var"] to delay evaluating securely stored credentials.
The following keys are accepted by Authenticationassoc:
"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
DataConnectionObject creates a reference to a data source. The source does not need to exist yet.
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)