{ "_id": "657760def0e8ddcea3885197", "oid": "16aa0d68-8f74-40de-a402-ce0b385ddcef", "title": "Sample Healthcare - Automatic Cascading Filter Test", "type": "extract", "relationType": "regular", "relationsTables": [], "enableDimensionalModeling": null, "server": "LocalHost", "buildDestination": { "destination": "elasticube", "database": null, "schema": null }, "modelStatistics": { "enableModelStatistics": false, "maxTablesPerCollection": null, "recollectStatsInterval": null }, "fiscal": "system", "relations": [ { "oid": "524580b9-b22d-40f8-8f84-ff115e88069c", "type": null, "columns": [ { "dataset": "8a6cb3da-b292-4d28-a446-d26fa4d313ec", "table": "16cf309d-6013-4b8d-9fa8-741d1cef576f", "column": "28e9f773-aa20-4e69-b638-481bbb2b6d74" }, { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "96f20dca-d609-4653-8be8-4fcb9cb5f121" } ] }, { "oid": "fcad29ee-6c8e-405c-913f-e1d5df9fff48", "type": null, "columns": [ { "dataset": "646208f4-9497-4055-8504-01b284091210", "table": "595070bb-effc-4fe5-8032-b88a01bca193", "column": "80ce0476-fede-4ae8-a366-efe9f27e5037" }, { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "b0de71bb-cd6a-4828-8e8a-1d4fa736a0d4" } ] }, { "oid": "0fceb0bc-b746-4781-bd21-36872109a293", "type": null, "columns": [ { "dataset": "203ae729-7902-438e-92c6-7b79cc9779fe", "table": "2753b8ba-337f-4d10-b4a1-933e0e231dfe", "column": "bedd18c5-f0b5-469b-aa45-2ae96766ac44" }, { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "0e39ee85-82c1-4c0d-889b-3687acfa88b9" } ] }, { "oid": "71638deb-f8a8-42f9-923b-aa3e9c657ade", "type": null, "columns": [ { "dataset": "e4cb5055-01b1-4488-b784-d8f7a291a656", "table": "7a7891fc-e777-4c5e-b1fc-1420f87036a7", "column": "d65fe477-472f-46db-934f-e33c07b655f8" }, { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "f992200b-c98f-4979-bd41-4f02a1068f38" } ] }, { "oid": "daf85c1a-ac16-4ffb-9e11-d9e16fc9e769", "type": null, "columns": [ { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "be61df1c-5b0c-431a-b869-21b9948c9527" }, { "dataset": "1d15dd69-8b52-458b-9b63-20a69c485795", "table": "400c8dca-3ca3-40bc-a54b-1338e68fad46", "column": "e08a335f-999c-42e3-85f4-a3707d85f0cf" } ] }, { "oid": "3da57808-930e-495d-a9b5-a79680dfd50d", "type": null, "columns": [ { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "4aa25ff0-8e77-47bf-a2ef-3a7133a18c9d" }, { "dataset": "a908178a-b76a-41e3-9d7f-a5cb7e167502", "table": "7cd6b5ac-7888-48e4-bcd0-13f05bcf94c4", "column": "76de3bf1-55cb-47ce-84b3-bf90e6ada0e9" } ] }, { "oid": "0d41d438-562d-47de-8c3e-6aee0b32b35a", "type": null, "columns": [ { "dataset": "2a070175-7958-4dde-bbf4-35dfd267ef23", "table": "0099cc95-70c9-404f-9513-af16a7fd8350", "column": "2ce971cc-6b9d-4f1c-a542-5431a9280353" }, { "dataset": "1b3bf274-3d98-47f8-945f-7121addd448f", "table": "907a5417-3c74-4e7c-8474-6f233a4a5282", "column": "18346d5c-e77b-43e2-9222-cb914b3f1dea" } ] } ], "datasets": [ { "oid": "1b3bf274-3d98-47f8-945f-7121addd448f", "fullname": "ac754e8d-2c89-4045-974a-205fa7ad362c", "database": "", "schemaName": "", "type": "custom", "name": "ac754e8d-2c89-4045-974a-205fa7ad362c", "modelingTransformations": [], "schema": { "tables": [ { "oid": "907a5417-3c74-4e7c-8474-6f233a4a5282", "id": "Discharge Date (1)", "name": "Last Visit Date", "role": null, "isRoleBySystem": null, "type": "custom", "schemaName": null, "expression": { "oid": "2c57fe33-9120-49d2-a808-c6043b421f46", "expression": "SELECT DISTINCT a.[Last_Visit_Date]\nFROM [Admissions] a", "isDatabaseDialect": false }, "columns": [ { "oid": "18346d5c-e77b-43e2-9222-cb914b3f1dea", "id": "59013f86-5e83-4187-a3cb-47d9847ad669", "name": "Last_Visit_Date", "role": null, "isRoleBySystem": null, "type": 19, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "907a5417-3c74-4e7c-8474-6f233a4a5282", "isMaterialized": null } ] }, "connection": null, "liveQuerySettings": null }, { "oid": "1d15dd69-8b52-458b-9b63-20a69c485795", "fullname": "d25f6b04-c6c5-457d-a20e-d2a127084a5b", "database": "", "schemaName": "", "type": "custom", "name": "d25f6b04-c6c5-457d-a20e-d2a127084a5b", "modelingTransformations": [], "schema": { "tables": [ { "oid": "400c8dca-3ca3-40bc-a54b-1338e68fad46", "id": "Admission Date", "name": "Admission Date", "role": null, "isRoleBySystem": null, "type": "custom", "schemaName": null, "expression": { "oid": "739b7bef-ab90-4441-8e13-75e9db529d8f", "expression": "SELECT DISTINCT a.[Admission_Date]\nFROM [Admissions] a", "isDatabaseDialect": false }, "columns": [ { "oid": "e08a335f-999c-42e3-85f4-a3707d85f0cf", "id": "4ef0580b-0b08-4d6c-83e1-fe8d3299dc16", "name": "Admission_Date", "role": null, "isRoleBySystem": null, "type": 19, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "400c8dca-3ca3-40bc-a54b-1338e68fad46", "isMaterialized": null } ] }, "connection": null, "liveQuerySettings": null }, { "oid": "203ae729-7902-438e-92c6-7b79cc9779fe", "fullname": "CSV:150e2a09-bafb-403e-a52d-2dc7d2d3fe53", "database": "", "schemaName": "CSVFile", "type": "extract", "name": "150e2a09-bafb-403e-a52d-2dc7d2d3fe53", "modelingTransformations": [], "schema": { "tables": [ { "oid": "2753b8ba-337f-4d10-b4a1-933e0e231dfe", "id": "Doctors.csv", "name": "Doctors", "role": null, "isRoleBySystem": null, "type": "base", "schemaName": null, "columns": [ { "oid": "bedd18c5-f0b5-469b-aa45-2ae96766ac44", "id": "ID", "name": "ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "2ee71e10-be09-4b1e-855e-65d13da762e6", "id": "Name", "name": "Name", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "75f5a27b-700a-4e6b-8583-e315151a8663", "id": "Surname", "name": "Surname", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "2e8c8cf1-8f90-40ea-9194-177d60bdb1ab", "id": "Specialty", "name": "Specialty", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "4eb1d595-2ff0-4a2a-bdcb-d8c80f1d83bc", "id": "Division_ID", "name": "Division_ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [ { "arguments": { "id": "a8ec5bf70LQAab216LQAa4caeLQAa8f39LQAacb5b72f7dfd2", "name": "Full Name", "type": 18, "size": 65536, "scale": 0, "precision": 0, "lastUpdated": "2023-12-11T18:41:34.012Z", "oid": "a3b08d30-036d-43a7-abb6-1a27f8c2b854", "hidden": false, "indexed": true, "isUpsertBy": false, "expression": { "lastUpdated": "2018-11-12T04:06:39.945Z", "oid": "412cc1a3-dc2a-4321-8890-f4805d776988", "expression": "[Name]+' '+[Surname]" } }, "type": "add-column" }, { "arguments": { "id": "Full Name_2", "name": "Full Name_2", "type": 18, "size": 65536, "scale": 0, "precision": 0, "lastUpdated": "2023-09-12T18:21:03.214Z", "oid": "5cad98d1-de04-4d44-9e27-74602b7f5a13", "hidden": false, "indexed": true, "isUpsertBy": false, "expression": { "lastUpdated": "2023-09-12T18:19:47.232Z", "oid": "1ac17976-ed65-4cb9-ad3f-bcb0c922ec2e", "expression": "[Name]+' '+[Surname]", "isDatabaseDialect": false } }, "type": "add-column" }, { "arguments": { "id": "Full Name_3", "name": "Full Name_3", "type": 18, "size": 65536, "scale": 0, "precision": 0, "lastUpdated": "2023-09-12T18:21:01.351Z", "oid": "82c8403c-42ce-4961-9358-8fd82751293e", "hidden": false, "indexed": true, "isUpsertBy": false, "expression": { "lastUpdated": "2023-09-12T18:19:51.076Z", "oid": "9e81a562-4737-4cdd-9732-fafbb6995196", "expression": "[Name]+' '+[Surname]", "isDatabaseDialect": false } }, "type": "add-column" } ], "hidden": false, "vTag": "2753b8ba-337f-4d10-b4a1-933e0e231dfe", "configOptions": { "Table": "Doctors.csv", "delimiter": ",", "hasHeader": true, "stringQuote": "\"", "ignoreFirstRows": 0, "ignoreLastRows": 0 }, "isMaterialized": false } ] }, "connection": { "oid": "370c4c3e-4338-4cf0-bb87-ddbaf8af34a7", "id": "657760de10b817002d9aa025", "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJ0Z25jbzdjQ3BWTnZnYWNSNCt4VVZjY3ViOXVuRlF6MTBHcDZiZFFXd29maktHUFdpaWdiWXJubVNGSzdjV0NvYzUySUlnUDFBVHpzSXNZYWZ1WWIzTXpZazdXZzlEUmJGSlNjR2JNeVhEZDVDZFZRdUsrUTJzZ0ZOMjVrVWpkODljS3JhKy9GQjE0alV2d3MrNkpZK2xKVlh6ZEVNbEMyVzlHNTg5NEtiR3o4a1UwSklaY1NDNGhRcWppZHNNQ0svLzJZZGRnT0RGY3BjcTdvWFo5YTBTSmhwYnJHbk9vQ2pVYnJRS1ZITHhmT3RLQmsrdXoyS1pZQkQ0UEJGTDNXTEZSQ3MwZC9oUktneUl6aGUwRlp3UXhxWlVWYVFmNjNGYUlCYTRMWFVIST0iLCJub25jZSI6Inc0SHo1dTRBRFEwbHpEQjV1OWRKakE9PSJ9LCJlbmNyeXB0aW9uTWV0YWRhdGEiOnsicHJvdmlkZXIiOiJMT0NBTCIsImtleUlkIjoiMTIzIiwiZW5jcnlwdGlvblRpbWUiOiIyMDIzLTEyLTExVDE5OjUwOjEzLjg5MTYzMDMwN1oifX0=", "schema": "CSVFile", "fileName": null, "protectedParameters": [], "uiParams": null, "globalTableConfigOptions": null }, "liveQuerySettings": null }, { "oid": "2a070175-7958-4dde-bbf4-35dfd267ef23", "fullname": "CSV:3c4c5282-83be-41b6-9a9e-ba0823fad8c9", "database": "", "schemaName": "CSVFile", "type": "extract", "name": "3c4c5282-83be-41b6-9a9e-ba0823fad8c9", "modelingTransformations": [], "schema": { "tables": [ { "oid": "0099cc95-70c9-404f-9513-af16a7fd8350", "id": "Admissions.csv", "name": "Admissions", "role": null, "isRoleBySystem": null, "type": "base", "schemaName": null, "columns": [ { "oid": "3f43ec88-773b-403b-ba6b-0fd4a53e1dda", "id": "ID", "name": "ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "96f20dca-d609-4653-8be8-4fcb9cb5f121", "id": "Patient_ID", "name": "Patient_ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "b0de71bb-cd6a-4828-8e8a-1d4fa736a0d4", "id": "Diagnosis_ID", "name": "Diagnosis_ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "f992200b-c98f-4979-bd41-4f02a1068f38", "id": "Room_ID", "name": "Room_ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "0e39ee85-82c1-4c0d-889b-3687acfa88b9", "id": "Doctor_ID", "name": "Doctor_ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "e6f55504-8f10-4fd1-b2dd-63e49216f23b", "id": "Admission_Time", "name": "Admission_Time", "role": null, "isRoleBySystem": null, "type": 4, "size": 8, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "4ed41e17-d5dd-4b2e-b0c8-1b013ea3b128", "id": "Discharge_Time", "name": "Discharge_Time", "role": null, "isRoleBySystem": null, "type": 4, "size": 8, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "01fbcb0a-1ce3-40c8-83be-495e67e7f5ea", "id": "HAI", "name": "HAI", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "3285f80d-a843-4f04-a1a6-ef0640a75e58", "id": "Surgical_Procedure", "name": "Surgical_Procedure", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "c898eb72-4be9-4024-afb9-c0ee1a244ed8", "id": "SSI", "name": "SSI", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "66f972f6-dbe8-44f8-b575-497a64b209d4", "id": "Cost_of_admission", "name": "Cost_of_admission", "role": null, "isRoleBySystem": null, "type": 5, "size": 50, "precision": 16, "scale": 16, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "106f639c-ac6b-498b-893e-7c98083ab8ae", "id": "Death", "name": "Death", "role": null, "isRoleBySystem": null, "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [ { "arguments": { "id": "a57978b45LQAa91bdLQAa48a5LQAa9b2aLQAa5e4f9f493a5d", "name": "Time of Stay", "type": 8, "size": 65536, "scale": 0, "precision": 0, "lastUpdated": "2023-12-11T18:41:34.010Z", "oid": "abfb6617-0d97-41d5-8fc4-1346cae0f3f2", "hidden": false, "indexed": false, "isUpsertBy": false, "expression": { "lastUpdated": "2018-11-12T04:06:39.935Z", "oid": "8d2d8979-0629-429e-9641-39fc523f62e7", "expression": "HourDiff([Discharge_Time],[Admission_Time])" } }, "type": "add-column" }, { "arguments": { "id": "Admission_Time_Int", "name": "Admission_Time_Int", "type": 0, "size": 0, "scale": 0, "precision": 0, "lastUpdated": "2022-11-08T15:29:15.642Z", "oid": "d1f385b8-4d89-40b6-a15c-202cb1130e66", "hidden": false, "indexed": true, "isUpsertBy": false, "expression": { "lastUpdated": "2022-11-08T15:29:15.642Z", "oid": "26dec5f4-1a5e-4b57-b305-9f1f37343206", "expression": "-- Changing datatype to bigint\n\ntobigint(\n\n--formatting date\n\nreplaceall(StrParts(tostring([Admission_Time]), ' ',1),'-','') +\n\n-- formatting time \n\nreplaceall(left(SubString(tostring([Admission_Time]),12),8),':',''))", "isDatabaseDialect": false } }, "type": "add-column" }, { "arguments": { "id": "Admission_Date", "name": "Admission_Date", "type": 19, "size": 8, "scale": 0, "precision": 0, "lastUpdated": "2023-12-11T18:47:35.030Z", "oid": "be61df1c-5b0c-431a-b869-21b9948c9527", "hidden": false, "indexed": false, "isUpsertBy": false, "expression": { "lastUpdated": "2023-12-11T18:48:17.435Z", "oid": "27a8be89-eb9b-4730-982f-61df26009558", "expression": "createdate(getyear([Admission_Time]), getmonth([Admission_Time]), getday([Admission_Time]))", "isDatabaseDialect": false }, "description": null, "role": null, "isRoleBySystem": null }, "type": "add-column" }, { "arguments": { "id": "Discharge_Date", "name": "Discharge_Date", "type": 19, "size": 8, "scale": 0, "precision": 0, "lastUpdated": "2023-12-11T18:47:39.576Z", "oid": "4aa25ff0-8e77-47bf-a2ef-3a7133a18c9d", "hidden": false, "indexed": false, "isUpsertBy": false, "expression": { "lastUpdated": "2023-12-11T18:48:36.899Z", "oid": "4ed553bc-5366-4740-b3d5-888a93154a4f", "expression": "createdate(getyear([Discharge_Time]), getmonth([Discharge_Time]), getday([Discharge_Time]))", "isDatabaseDialect": false }, "description": null, "role": null, "isRoleBySystem": null }, "type": "add-column" }, { "arguments": { "id": "Last_Visit_Date", "name": "Last_Visit_Date", "type": 19, "size": 8, "scale": 0, "precision": 0, "lastUpdated": "2023-12-11T18:47:42.510Z", "oid": "2ce971cc-6b9d-4f1c-a542-5431a9280353", "hidden": false, "indexed": false, "isUpsertBy": false, "expression": { "lastUpdated": "2023-12-11T18:53:57.767Z", "oid": "19144a59-7096-43b0-856d-fc3aabf7e29e", "expression": "adddays([Discharge_Date], -1 * daydiff([Discharge_Date], [Admission_Date]) / 3)", "isDatabaseDialect": false }, "description": null, "role": null, "isRoleBySystem": null }, "type": "add-column" }, { "arguments": { "column": "2ce971cc-6b9d-4f1c-a542-5431a9280353", "type": 4 }, "type": "change-data-type" } ], "hidden": false, "vTag": "0099cc95-70c9-404f-9513-af16a7fd8350", "configOptions": { "Table": "Admissions.csv", "delimiter": ",", "hasHeader": true, "stringQuote": "\"", "ignoreFirstRows": 0, "ignoreLastRows": 0 }, "isMaterialized": false } ] }, "connection": { "oid": "313a8a75-a7ed-4489-b674-3fedeea60338", "id": "657760de10b817002d9aa023", "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJybU9ic1lBTWVNenVoODRNejVkZkUrRHd6YkhDOUZLd2lhTHRObnQwTkNoUmREMFBpYzMxT2lYYllnVUFYcW1ReWdML3FsK3RnVS9DN2M1UkgxR3ZFMWladFRscUsya1U2WlJjVHNBcnFZOGxkb1ZmOVczQUlKN2trMUVNV3A5d3lYdDBXeU9OMGtqbWdYSlFtWDJPT0FKWkxHNmx2c0ZsbHFlL0cxci9ubFBpTkQzZ0tWa3RKUjV1VEdiWHpaZENnQTYxL1BSN0diaSs2dW0wek92ZEtoN3JQZk56Wk05ODVnMHZhNk5jYytKOE9LcTd6MEVXNmt4Unlvb3V5a0Vma1NSY29vQzhZTThUYjBVNml4cFJ6Mnl3ckkyclh1Q0p0SzNlVFRQUnRhQ1ZZVk1WaFQrcEN5Z0RiTjh2RDlYayIsIm5vbmNlIjoiblA3SFZ3aTZEQXgzMXVBUHhDcTBOdz09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjMtMTItMTFUMTk6NTA6MTMuODkxNjMwMjc3WiJ9fQ==", "schema": "CSVFile", "fileName": null, "protectedParameters": [], "uiParams": null, "globalTableConfigOptions": null }, "liveQuerySettings": null }, { "oid": "646208f4-9497-4055-8504-01b284091210", "fullname": "CSV:2e87d39f-5bb7-4b99-979f-afc2f2d6057e", "database": "", "schemaName": "CSVFile", "type": "extract", "name": "2e87d39f-5bb7-4b99-979f-afc2f2d6057e", "modelingTransformations": [], "schema": { "tables": [ { "oid": "595070bb-effc-4fe5-8032-b88a01bca193", "id": "Diagnosis.csv", "name": "Diagnosis", "role": null, "isRoleBySystem": null, "type": "base", "schemaName": null, "columns": [ { "oid": "80ce0476-fede-4ae8-a366-efe9f27e5037", "id": "ID", "name": "ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "db694b8e-7735-446e-9ec1-e425f51da0a1", "id": "Description", "name": "Description", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "595070bb-effc-4fe5-8032-b88a01bca193", "configOptions": { "Table": "Diagnosis.csv", "delimiter": ",", "hasHeader": true, "stringQuote": "\"", "ignoreFirstRows": 0, "ignoreLastRows": 0 }, "isMaterialized": false } ] }, "connection": { "oid": "ca394cf1-52af-477c-ae0b-26029e1f457c", "id": "657760df10b817002d9aa02a", "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJEN0lYZFVkTzl3ZWpHcUoxdGVqNkhzajBlYUZDM0VERG9LWDVWbG5XZ0NiZklxKzFqZXptKy9mM2RERnBkWWluelVsVXZVa2EwM0tBc3h3TUtJQ3VGR29GY1hWZCtIV0kza2QyT2FhM0Nkb2Y2VDhSaHVzSkI5YzhacHF6d0RNd21NWCt6RzlEUnJ5Sk1WMFJpMjN5aUVpaTVCZmZWeU4vRng5cmtBQW9QTUxjRW94ZnJYTlZOQjh1QnR3OW5XcnZ4U1YxTXNkV3YvY3J0YWVOaklOVW5QcEhhOTJ3QTBqRVRIeEJIcm5IekhuWFhWdEpMNFBsQkl4QnRFZC9VOWY1bGN4aGJjSG5BNERSdXFUcmxuckFMczNTMnhaTUZlZUl6cTA4Z0ZsME9nN2Q1bnV2ZDNtL2pMWnB6N3ZDbHBDRSIsIm5vbmNlIjoiRGpBeC94N3JtUnJRMTdGZGMrNGsrdz09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjMtMTItMTFUMTk6NTA6MTMuODk1MjkzNDA0WiJ9fQ==", "schema": "CSVFile", "fileName": null, "protectedParameters": [], "uiParams": null, "globalTableConfigOptions": null }, "liveQuerySettings": null }, { "oid": "8a6cb3da-b292-4d28-a446-d26fa4d313ec", "fullname": "CSV:84a46fd0-4526-4cde-928e-ded9491e9842", "database": "", "schemaName": "CSVFile", "type": "extract", "name": "84a46fd0-4526-4cde-928e-ded9491e9842", "modelingTransformations": [], "schema": { "tables": [ { "oid": "16cf309d-6013-4b8d-9fa8-741d1cef576f", "id": "Patients.csv", "name": "Patients", "role": null, "isRoleBySystem": null, "type": "base", "schemaName": null, "columns": [ { "oid": "0eab9c66-585c-4461-a397-89e771cc1025", "id": "Name", "name": "Name", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "7f343e8b-d767-4be9-b65c-4b3c07ef33f4", "id": "Surname", "name": "Surname", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "8f8b53c9-3881-4164-ac98-82f0d872f273", "id": "DOB", "name": "DOB", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null }, { "oid": "28e9f773-aa20-4e69-b638-481bbb2b6d74", "id": "ID", "name": "ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 9, "precision": 15, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "dcbca9be-d89a-44e7-bfe2-9818ebc0bfb1", "id": "Gender", "name": "Gender", "role": null, "isRoleBySystem": null, "type": 18, "size": 65536, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [ { "arguments": { "id": "ace4c17c5LQAa1488LQAa4d56LQAa9c2bLQAae73b80de58c0", "name": "Full Name", "type": 18, "size": 65536, "scale": 0, "precision": 0, "lastUpdated": "2023-12-11T18:41:34.012Z", "oid": "ca0e756e-d13d-412a-a7fa-25ba9023d78a", "hidden": false, "indexed": true, "isUpsertBy": false, "expression": { "lastUpdated": "2018-11-12T04:06:39.916Z", "oid": "4b8006fa-8a50-4832-a2c3-9ddd6faa7af2", "expression": "[Name]+' '+[Surname]" } }, "type": "add-column" } ], "hidden": false, "vTag": "16cf309d-6013-4b8d-9fa8-741d1cef576f", "configOptions": { "Table": "Patients.csv", "delimiter": ",", "hasHeader": true, "stringQuote": "\"", "ignoreFirstRows": 0, "ignoreLastRows": 0 }, "isMaterialized": false } ] }, "connection": { "oid": "1dfc4284-75c9-4a7e-bb72-264e6a3dc626", "id": "657760df10b817002d9aa02d", "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJUOWJ4R1NVS21yNWRQV1VUeGkrWjZKR1c5WGRUNHJTd1FmWnVOY1Y1ZWVOb1dBdzE3YkhCeStiTHBsWVphbTd0ZEtNOEFDQ1NMbitzNEFEZlNxS2JyUENZOURWTXBpbElRYityWmwxemNsRkVxVkd1U3QyT1NQbmVVdmV3dUdIUXFGdzFSdzdHbEZlUFRzRmlBSlVoQWJlYmNsMytDVG1BWjJkS1l5MUFVSTB4UDA0TzRITDBPVlZuemJvckhTcG5NUVNxMEV4bnhtc1ZFY080Y25DWTAvb2V2UUw1UThlUXBBb09sMGZ4Z1N2d21zUGFGQXlBbnlvd0tmSEtwZWp4bTFRUmJabHVJUnZNYjhuWWJoVGhiR1R2dEc0YTh1dXFyUUN6S0J4RnQxdGNSNkNsOU0yakpzZWE3RUlrUDE4NSIsIm5vbmNlIjoiY1k2MUlGRkszK1BpRjBpeHVoZGttQT09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjMtMTItMTFUMTk6NTA6MTMuODkxODQwNzEyWiJ9fQ==", "schema": "CSVFile", "fileName": null, "protectedParameters": [], "uiParams": null, "globalTableConfigOptions": null }, "liveQuerySettings": null }, { "oid": "a908178a-b76a-41e3-9d7f-a5cb7e167502", "fullname": "789e31cb-9b10-40f2-b140-29297811d313", "database": "", "schemaName": "", "type": "custom", "name": "789e31cb-9b10-40f2-b140-29297811d313", "modelingTransformations": [], "schema": { "tables": [ { "oid": "7cd6b5ac-7888-48e4-bcd0-13f05bcf94c4", "id": "Admission Date (1)", "name": "Discharge Date", "role": null, "isRoleBySystem": null, "type": "custom", "schemaName": null, "expression": { "oid": "659e59ba-1f7e-4c5d-85f0-bbf0cbde6c1b", "expression": "SELECT DISTINCT a.[Discharge_Date]\nFROM [Admissions] a", "isDatabaseDialect": false }, "columns": [ { "oid": "76de3bf1-55cb-47ce-84b3-bf90e6ada0e9", "id": "bc09df12-2d43-4ddd-86e0-794bfa6a577a", "name": "Discharge_Date", "role": null, "isRoleBySystem": null, "type": 19, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "7cd6b5ac-7888-48e4-bcd0-13f05bcf94c4", "isMaterialized": null } ] }, "connection": null, "liveQuerySettings": null }, { "oid": "e4cb5055-01b1-4488-b784-d8f7a291a656", "fullname": "CSV:e34a33f6-b8dc-4c78-b51c-e7cfb4f0c79b", "database": "", "schemaName": "CSVFile", "type": "extract", "name": "e34a33f6-b8dc-4c78-b51c-e7cfb4f0c79b", "modelingTransformations": [], "schema": { "tables": [ { "oid": "7a7891fc-e777-4c5e-b1fc-1420f87036a7", "id": "Rooms.csv", "name": "Rooms", "role": null, "isRoleBySystem": null, "type": "base", "schemaName": null, "columns": [ { "oid": "d65fe477-472f-46db-934f-e33c07b655f8", "id": "ID", "name": "ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "0a4dd01e-f6b6-47bc-9c41-1e72448f3e7e", "id": "Room_number", "name": "Room_number", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "d0ace1c1-4e39-4ae9-be69-b9094db90897", "id": "Division_ID", "name": "Division_ID", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null }, { "oid": "6553eb3e-ac0c-4cd1-b32b-9add99ec82d5", "id": "Bed_count", "name": "Bed_count", "role": null, "isRoleBySystem": null, "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "isUpsertBy": false, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "7a7891fc-e777-4c5e-b1fc-1420f87036a7", "configOptions": { "Table": "Rooms.csv", "delimiter": ",", "hasHeader": true, "stringQuote": "\"", "ignoreFirstRows": 0, "ignoreLastRows": 0 }, "isMaterialized": false } ] }, "connection": { "oid": "bcf63986-b5d7-4846-9861-d35e70ba5fe8", "id": "657760df10b817002d9aa027", "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJWdUxYcGlrWlVwYk8vTG9Xamp4eWptL2xHWHZwTUU1Z2habjkvek4vR1Zxd0I2TW9lT1krc1BUUlZERHZXNkVNRWtHSENKdW9rangyQ1dKdjJvaXpBYUJOVUlhVkw2cTc3WHZJa203bFFKWE5SSldKOG4wRVV1Zm93SWd2L21aZlJGcXFCbG02SW9zVlhEdWtCdmNrK1RXMHp2UjgxRklXZndzUXZ4QnNlMEY0dkRXVEFnbSt3Wk8wWDluQVFJYlExMHRucm9iczhXb24xSHJRMm10dUlGNFFtakowSHJ3em4xTmxPdUpmTW1mQWxOSGRJQ245d1IzNlNpWGFjK2x0MlB0S2RyMXFjeWVWMGhVNnczWGdyZmVqTG9rZE5aWDVqZDdBd1ZpSGtMTT0iLCJub25jZSI6Im5UU0dJUSt1UGlGYlRWRFMvRHBYclE9PSJ9LCJlbmNyeXB0aW9uTWV0YWRhdGEiOnsicHJvdmlkZXIiOiJMT0NBTCIsImtleUlkIjoiMTIzIiwiZW5jcnlwdGlvblRpbWUiOiIyMDIzLTEyLTExVDE5OjUwOjEzLjg5MTk0NzU4NFoifX0=", "schema": "CSVFile", "fileName": null, "protectedParameters": [], "uiParams": null, "globalTableConfigOptions": null }, "liveQuerySettings": null } ], "perspectives": [ { "_id": "657760df10b817002d9aa030", "oid": "16aa0d68-8f74-40de-a402-ce0b385ddcef", "datamodelOid": "16aa0d68-8f74-40de-a402-ce0b385ddcef", "description": "", "tables": [], "parentOid": null, "name": "Default", "isDefault": true } ], "dependencies": {} }