Skip to content

Instantly share code, notes, and snippets.

@prmoore77

prmoore77/product_reporting_dim_table_contents.csv

Created June 7, 2022 17:55
Show Gist options
  • Save prmoore77/51316ed2997a0d1984896ec268a1a5e7 to your computer and use it in GitHub Desktop.
Save prmoore77/51316ed2997a0d1984896ec268a1a5e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
product_reporting_dim_table_contents.csv
node_id node_natural_key node_name level_name parent_node_id is_root is_leaf level_number node_json node_json_path node_sort_order level_1_node_id level_1_node_natural_key level_1_node_name level_1_level_name level_2_node_id level_2_node_natural_key level_2_node_name level_2_level_name level_3_node_id level_3_node_natural_key level_3_node_name level_3_level_name
71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products TRUE FALSE 1 {'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1, 'node_sort_order': 1} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}] 1 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products
0e81b2fb-c845-4ca0-a001-34780b4b3bae 20 Candy Category 71ed36fa-3944-9aa0-a017-30872d0d4f13 FALSE FALSE 2 {'node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'node_natural_key': 20, 'node_name': Candy, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2, 'node_sort_order': 2} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}, {'node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'node_natural_key': 20, 'node_name': Candy, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2}] 2 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products 0e81b2fb-c845-4ca0-a001-34780b4b3bae 20 Candy Category
1ef9d2eb-e14b-2080-8026-1f1040728321 201 Hershey Bar UPC 0e81b2fb-c845-4ca0-a001-34780b4b3bae FALSE TRUE 3 {'node_id': 1ef9d2eb-e14b-2080-8026-1f1040728321, 'node_natural_key': 201, 'node_name': Hershey Bar, 'level_name': UPC, 'parent_node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'is_root': False, 'is_leaf': True, 'level_number': 3, 'node_sort_order': 3} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}, {'node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'node_natural_key': 20, 'node_name': Candy, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2}, {'node_id': 1ef9d2eb-e14b-2080-8026-1f1040728321, 'node_natural_key': 201, 'node_name': Hershey Bar, 'level_name': UPC, 'parent_node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'is_root': False, 'is_leaf': True, 'level_number': 3}] 3 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products 0e81b2fb-c845-4ca0-a001-34780b4b3bae 20 Candy Category 1ef9d2eb-e14b-2080-8026-1f1040728321 201 Hershey Bar UPC
8d8b9c76-fd41-b7b9-b9fd-10d22f5ae767 202 Nerds UPC 0e81b2fb-c845-4ca0-a001-34780b4b3bae FALSE TRUE 3 {'node_id': 8d8b9c76-fd41-b7b9-b9fd-10d22f5ae767, 'node_natural_key': 202, 'node_name': Nerds, 'level_name': UPC, 'parent_node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'is_root': False, 'is_leaf': True, 'level_number': 3, 'node_sort_order': 4} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}, {'node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'node_natural_key': 20, 'node_name': Candy, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2}, {'node_id': 8d8b9c76-fd41-b7b9-b9fd-10d22f5ae767, 'node_natural_key': 202, 'node_name': Nerds, 'level_name': UPC, 'parent_node_id': 0e81b2fb-c845-4ca0-a001-34780b4b3bae, 'is_root': False, 'is_leaf': True, 'level_number': 3}] 4 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products 0e81b2fb-c845-4ca0-a001-34780b4b3bae 20 Candy Category 8d8b9c76-fd41-b7b9-b9fd-10d22f5ae767 202 Nerds UPC
c999bd14-9b47-64ae-ae6c-e0dd294e6912 10 Produce Category 71ed36fa-3944-9aa0-a017-30872d0d4f13 FALSE FALSE 2 {'node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'node_natural_key': 10, 'node_name': Produce, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2, 'node_sort_order': 5} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}, {'node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'node_natural_key': 10, 'node_name': Produce, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2}] 5 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products c999bd14-9b47-64ae-ae6c-e0dd294e6912 10 Produce Category
2ba26113-f841-bebf-bf7f-8372c5de9f5f 101 Spinach UPC c999bd14-9b47-64ae-ae6c-e0dd294e6912 FALSE TRUE 3 {'node_id': 2ba26113-f841-bebf-bf7f-8372c5de9f5f, 'node_natural_key': 101, 'node_name': Spinach, 'level_name': UPC, 'parent_node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'is_root': False, 'is_leaf': True, 'level_number': 3, 'node_sort_order': 6} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}, {'node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'node_natural_key': 10, 'node_name': Produce, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2}, {'node_id': 2ba26113-f841-bebf-bf7f-8372c5de9f5f, 'node_natural_key': 101, 'node_name': Spinach, 'level_name': UPC, 'parent_node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'is_root': False, 'is_leaf': True, 'level_number': 3}] 6 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products c999bd14-9b47-64ae-ae6c-e0dd294e6912 10 Produce Category 2ba26113-f841-bebf-bf7f-8372c5de9f5f 101 Spinach UPC
360e9210-2a4f-7bb8-b8ad-787981570ff7 102 Tomatoes UPC c999bd14-9b47-64ae-ae6c-e0dd294e6912 FALSE TRUE 3 {'node_id': 360e9210-2a4f-7bb8-b8ad-787981570ff7, 'node_natural_key': 102, 'node_name': Tomatoes, 'level_name': UPC, 'parent_node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'is_root': False, 'is_leaf': True, 'level_number': 3, 'node_sort_order': 7} [{'node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'node_natural_key': 0, 'node_name': All Products, 'level_name': Total Products, 'parent_node_id': NULL, 'is_root': True, 'is_leaf': False, 'level_number': 1}, {'node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'node_natural_key': 10, 'node_name': Produce, 'level_name': Category, 'parent_node_id': 71ed36fa-3944-9aa0-a017-30872d0d4f13, 'is_root': False, 'is_leaf': False, 'level_number': 2}, {'node_id': 360e9210-2a4f-7bb8-b8ad-787981570ff7, 'node_natural_key': 102, 'node_name': Tomatoes, 'level_name': UPC, 'parent_node_id': c999bd14-9b47-64ae-ae6c-e0dd294e6912, 'is_root': False, 'is_leaf': True, 'level_number': 3}] 7 71ed36fa-3944-9aa0-a017-30872d0d4f13 0 All Products Total Products c999bd14-9b47-64ae-ae6c-e0dd294e6912 10 Produce Category 360e9210-2a4f-7bb8-b8ad-787981570ff7 102 Tomatoes UPC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment