@RunLLM what can you do in Python with MotherDuck?

RunLLM what can you do in Python with MotherDuck?

· Sorted by Oldest

RunLLM what can you do in Python with MotherDuck?

· Sorted by Oldest

RunLLM
APP
·
In Python, you can use MotherDuck to connect to databases, load data, and execute queries. You can connect to MotherDuck using the duckdb.connect function with a connection string, and perform SQL operations directly or through Python functions. Data can be loaded into MotherDuck using SQL commands like CREATE TABLE AS SELECT for various file formats such as CSV, Parquet, and JSON from local or cloud sources. For detailed operations and examples, you can refer to the Using Python documentation on MotherDuck's website.Would you like more detailed examples or specific use cases on how to implement these operations in Python?Sources: - Using Python
💡 Hint: Mention RunLLM in the thread for followups.
John D.
·
A simple answer would be: everything! Great API very fast, easy to use and, if so inclined, there are other APIs such as SQLAlchemy Prior to starting with MD, I did not know Python at all well. Now, after months of testing, I find it a great language as not only does it support MD and DuckDB, it also supports, either through DuckDB reading from many sources such as S3, but also natively supports lots of different data type and databases
🙌1

RunLLM
APP
·
In Python, you can use MotherDuck to connect to databases, load data, and execute queries. You can connect to MotherDuck using the duckdb.connect function with a connection string, and perform SQL operations directly or through Python functions. Data can be loaded into MotherDuck using SQL commands like CREATE TABLE AS SELECT for various file formats such as CSV, Parquet, and JSON from local or cloud sources. For detailed operations and examples, you can refer to the Using Python documentation on MotherDuck's website.Would you like more detailed examples or specific use cases on how to implement these operations in Python?Sources: - Using Python
💡 Hint: Mention RunLLM in the thread for followups.
John D.
·
A simple answer would be: everything! Great API very fast, easy to use and, if so inclined, there are other APIs such as SQLAlchemy Prior to starting with MD, I did not know Python at all well. Now, after months of testing, I find it a great language as not only does it support MD and DuckDB, it also supports, either through DuckDB reading from many sources such as S3, but also natively supports lots of different data type and databases
🙌1