The Staging Area is also the location where you perform joins between tables, and select which fields in a table are imported.Ī panel for building simple or compound filters that precisely specify which records from a data set are imported.Ī preview of the data exactly as it will be imported into Analytics.Īs you work with the data by joining tables, omitting fields, and creating filters, you can refresh the preview to see the effect of your changes. The area in the Data Access window that contains the table or tables you have selected for import. If additional tables exist, you can click a link to display them in blocks of up to 500 tables at a time.
The first 200 tables in the source data are displayed. The tables in the source data that are available for import. Includes the name of the connection, and the name of the database, or the location of the file, containing the source data.Ī search box for progressively filtering the list of available tables in the source data.Īs you enter characters in the search box, the Available Tables list is filtered so that it contains only tables names with a matching string of characters. The features contained in the Data Access window are explained below.ĭisplays information about the currently active data connection. Editing the SQL to write to the data source is not supported.
You can edit the SQL import statement used to access data in an external database or file. The Data Access window is an import-only tool.
0 kommentar(er)
