Skip to content

Latest commit

 

History

History
37 lines (31 loc) · 1.16 KB

README.md

File metadata and controls

37 lines (31 loc) · 1.16 KB
Raw

Welcome to your new dbt project!

Using the starter project

Try running the following commands:

  • dbt run
  • dbt test

Resources:

  • Learn more about dbt in the docs
  • Check out Discourse for commonly asked questions and answers
  • Join the chat on Slack for live discussions and support
  • Find dbt events near you
  • Check out the blog for the latest news on dbt's development and best practices
duckdb dev.duckdb
create schema raw;
set schema='raw';
create table EchoFindingCodesEmbeddedInStudy as select * from '.private/EchoFindingCodesEmbeddedInStudy.csv';
create table EchoStudies as select * from '.private/EchoStudies.csv';
.exit
select
	EchoFindingCodesEmbeddedInStudy.*
from
	DataMining.dbo.EchoStudies
	inner join DataMining.dbo.EchoFindingCodesEmbeddedInStudy on EchoStudies.PerformedProcedureID = EchoFindingCodesEmbeddedInStudy.PerformedProcedureID
where
	1 = 1
	AND EchoStudies.FormattedProcedureDate < '20240101'--@EndDate
	AND EchoStudies.StudyConfig3 like '%TRANSCRANIAL%'
;