We are migrating from CD1 to CD2. In the accounts table the depth_of_account column is a calculation. Does anyone have SQL script to calculate the depth_of_account hierarchy and the subaccount_ids? Cu...

Thank you for your reply.  How the Account_Dim table in CD1 is set up the depth in account are related to Root Account = University;  Depth = 0 Subaccount 1 = Campus; Depth = 1 Subaccount 2 = College;...

I believe user_account_associations is a new table. I do not think this table or user_account_settings should be joined and used to calculate the depth in account as mentioned in the Public CD1 to CD2...

Hello,  I've attached an example of the Depth in Account levels we are trying to calculate.  Root Account = University Subaccount 1 = Campus Subaccount 2 = College Subaccount 3 = Department. It has be...

Sorry - we are not using Splunk. Hello,  The Canvas 1 to Canvas 2 documentation states Depth in Account is a calculated field: DepthSetting=20 . The "depth" field in CD2 table: "user_account_settings"...

Thank you for your reply.  How the Account_Dim table in CD1 is set up the depth in account are related to Root Account = University;  Depth = 0 Subaccount 1 = Campus; Depth = 1 Subaccount 2 = College;...

I believe user_account_associations is a new table. I do not think this table or user_account_settings should be joined and used to calculate the depth in account as mentioned in the Public CD1 to CD2...

Hello,  I've attached an example of the Depth in Account levels we are trying to calculate.  Root Account = University Subaccount 1 = Campus Subaccount 2 = College Subaccount 3 = Department. It has be...

Sorry - we are not using Splunk. Hello,  The Canvas 1 to Canvas 2 documentation states Depth in Account is a calculated field: DepthSetting=20 . The "depth" field in CD2 table: "user_account_settings"...

Hello,  I tried your script and it does not provide the correct results. The Canvas 1 to Canvas 2 documentation states Depth in Account is a calculated field: DepthSetting=20 . The "depth" field in CD...