Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

CONNECT EAP

TABLE OF CONTENTS

Create a virtual table

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJul 20, 2026
  • 2 minute read

A share must be established between CONNECT and Databricks before you can create a virtual table.

Timestamp precision

Virtual tables currently support timestamps with a maximum precision of microseconds (1 × 10⁻⁶ s), which is aligned with limitations in data lake platforms.

When data from CONNECT or upstream industrial sources includes timestamps with nanosecond precision, the additional fractional digits (beyond 6 decimals) are truncated or rounded during the virtual table creation process.

As a result:

  • The original nanosecond precision from CONNECT sources will not be preserved in the Delta table.

  • Downstream consumers such as Databricks, Power BI, or other BI tools via delta sharing will observe timestamps rounded to the nearest microsecond. This is currently limited to microsecond precision due to downstream platform or storage constraints. Higher precision is truncated or rounded during materialization.

Example:

2025-10-21T14:23:15.123456789Z is stored as 2025-10-21T14:23:15.123456Z.

Create a virtual table in CONNECT

To create a virtual table, perform the following steps:

  1. In the left pane, select Data modeling > Virtual Tables.

  2. Select the Virtual Tables tab.

  3. Select Create virtual table.

  4. Select a data view for use in your virtual table.

    For more information on data views, read Data views.

  5. Select Next.

  6. Type a name for your virtual table in the Name box.

    The name of your chosen data view is visible for reference.

  7. Select an Interpolated or Stored retrieval mode.

    • Interpolated: Returns data between specified intervals.

      If you select Interpolated, provide an Interpolation interval (dd.hh:mm:ss).

    • Stored: Returns stored or window data.

    For more information on data retrieval types, see Preview and save the data view.

  8. Select a Retrieval interval and provide a time window.

    • Time-Fixed Window: contains a beginning and an end time.

    • Time-Extending Window: only contains a start time.

      Provide a Refresh interval for the Scheduler configuration when you choose a Time-Extending Window.

  9. Select Next.

  10. Select the Share(s) you want in your virtual table.

    If you do not have an available share, select Create share. For more information on how to create a share, see Create a share.

  11. Select Next.

  12. Review the summary of your virtual table and select Save.

Create a catalog in Databricks

Once the virtual table has been shared with the target Databricks metastore, your Databricks metastore administrator will need to create a catalog for your workspace from the share. The virtual table will then appear in the catalog.

You will need the source metastore_id which is an AVEVA Databricks regional workspace. Contact AVEVA customer support to request this information. With that information, your Databricks administrator can find your virtual table. For example, a valid metastore_id will be in the following format: connect:northeurope.

For information about data access, permissions, and creating a catalog in Databricks, read the Databricks documentation.

In This Topic