Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table creation workflow. #18

Open
jwcook23 opened this issue Feb 1, 2022 · 1 comment
Open

Table creation workflow. #18

jwcook23 opened this issue Feb 1, 2022 · 1 comment
Labels
documentation Improvements or additions to documentation enhancement New feature or request

Comments

@jwcook23
Copy link
Owner

jwcook23 commented Feb 1, 2022

Provide a simple workflow with documentation on how a table may be initially created, while exposing what will happen before objects are created.

# this method doesn't exist, but would be useful as an intermediate step
schema = sql.infer.table_from_dataframe(df)

Then this workflow could follow.

sql.create.table(schema)
sql.write.insert(df)
@jwcook23 jwcook23 added documentation Improvements or additions to documentation enhancement New feature or request labels Feb 1, 2022
@jwcook23
Copy link
Owner Author

jwcook23 commented Feb 2, 2022

This can be directly quickly accomplished now by creating a global temporary table then using the get_schema method.

sql.create.table_from_dataframe(table_name='##test_schema', dataframe=data)
sql.get_schema('##test_schema')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant