Migrate an Existing Report to Procore Analytics 2.0 (Beta)
Objective
To migrate an existing Procore Analytics report to Procore Analytics 2.0.
Things to Consider
- Considerations:
- The Delta Sharing connector does not support advanced SQL query data nor does it support direct query.
- Some columns and tables have new names in Procore Analytics 2.0. See Rename Report Columns and Tables in Procore Analytics 2.0 (Beta).
Steps
- Open the report you want to migrate.
- Open the Query Editor.
- Click New Source then click More.
Note: The values you are given will not be the same as the values in the examples below. - In the search bar, type 'Delta Sharing'.
- Select Delta Sharing, then click Connect.
- Type or paste the Delta Sharing Server URL you received from the Procore.
- Select the table you want to migrate.
- In the new query, click Advanced Editor.
- Copy the contents before the word 'in'. This will include the 'Source' and 'Navigation' steps from the query.
Note: The screenshot below is just an example. Your values will be different.
- Click Done.
- Open the 'Company'.
- Replace the 'Source' and 'Navigation' steps with the ones copied from Step 9.
Note: Make sure you paste the text before the word 'in'. - Click Done.
- Add a comma at the end of your text if there are additional applied steps.
- Look through the query for errors that may occur. For example, some columns do not exist in the latest version of Procore Analytics so we can remove these from Applied Steps.
- Next, you will remap the project's table.
- Open Projects Query.
- Click Advanced Editor.
- Paste the same connection code from above (copied from companies query) to the first two lines of the project query (before any steps starting with #).
- The new query now looks like the screenshot below.
- Add a comma and change the code to point to a different table, like the example below:
Example:
Source = DeltaSharing.Contents("https://nvirginia.cloud.databricks.c...d-4692f841b2ca",
[rowLimitHint=null]),pa_internal_test = Source{[Name="pa_internal_test"]}[Data],
public_company_only = pa_internal_test{[Name="public_company_only"]}[Data],
companies1 = public_company_only{[Name="companies"]}[Data],
Change -> companies1 = public_company_only{[Name="companies"]}[Data],
To -> Projects = public_company_only{[Name="projects"]}[Data],
- “[Name=”projects”]” is what points to the correct table in Analytics 2.0.