astro-sdk
xidel
astro-sdk | xidel | |
---|---|---|
7 | 18 | |
317 | 652 | |
0.9% | - | |
8.5 | 5.6 | |
5 days ago | 11 days ago | |
Python | Pascal | |
Apache License 2.0 | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
astro-sdk
-
Orchestration: Thoughts on Dagster, Airflow and Prefect?
Have you tried the Astro SDK? https://github.com/astronomer/astro-sdk
-
Airflow as near real time scheduler
One interesting point about putting the data into s3, is that if the data is in an S3 file then OP can use the Astro SDK to pretty easily upload that data into a table or a dataframe (there's even an s3 dynamic task function in the SDK that might fit the use-case well here).
-
Most ideal Airflow task structure?
I think you should take a look at the Astro SDK It’s an open source python package that removes the complexity of writing DAGs , particularly in the context of Extract, Load, Transform (ELT) use cases. Look at the doc here, especially aql.transform, aql.run_raw_sql, etc. That will definitely help you
-
ELT pipeline using airflow
- Astro SDK*: Made for folks who are doing their ETL in airflow and want to simplify movement between DBs and Pandas
-
After Airflow. Where next for DE?
More of a general principle but when you don't have design patterns, you get varying levels of results right? I think what Astro is doing to introduce "strong defaults" through projects like the astro-sdk or the cloud ide are interesting experiments to remove some of the busy work of common dags (load from s3, do something, push to database) will HELP reduce the cognitive load of really common, simple actions and give them a better single pattern to optimize on. I don't think those efforts reduce the optionality of true power users at all who want to custom code their s3 log sink to have some unique implementation while at the same time maybe solving some of the fragmentation to very frequently performed operations. 🤞
-
Airflow - Passing large data volumes between tasks
Have you looked into the astro python SDK? My team and I built this out over the last year to do exactly this :). You can you use the `@dataframe` decorator to pull the API data into a dataframe, store it in GCS and the access it in future steps. Lemme know if you have any questions!
-
What's the best tool to build pipelines from REST APIs?
I have an example here using COVID data. basically you just write a python function that reads the API and returns a dataframe (or any number of dataframes) and downstream tasks can then read the output as either a dataframe or a SQL table.
xidel
-
Move over jq I found something easier: fx
You could try Xidel[1]. It supports JSON, XML and HTML using XPath/XQuery 3.1
It has some extensions to the standard that are pretty nice (JSONiq, CSS selectors, html “template” matching), but you can limit it to just standard XPath/XQuery if you like.
I recommend getting the nightly v .99 build if you give it a try, the stable .98 version is pretty old and I’ve had no issues with .99
1. https://www.videlibri.de/xidel.html
-
Batch Win Installer - from a defined list of software, BWI will install software on 64 bit Windows 10/11 x64 machine without prompts ; check what software is installed and offer to install and/or upgrade software and scan program's websites to determine the latest version of the software available
Windows binary of Xidel (https://github.com/benibela/xidel) a commandline tool to download and extract data from HTML pages
- pup: Parsing HTML at the Command Line
- Remove white spaces from last column of CSV
-
What's the best tool to build pipelines from REST APIs?
Xidel for extraction and pagination
-
What are your coolest tools for one-liners ?
Download an entire subreddit to JSON Lines with Xidel:
-
Fetch data from XML
I believe that you can't read from a url with batch alone. you'll need a helper app like xidel https://www.videlibri.de/xidel.html
-
Tutorial: Rapid Script Development with Bash, JC, and JQ (no grep/sed/awk)
I have not played with this, but it looks like xidel might allow you to do this in Bash. jc also has a URL string parser that could be used in such a script.
- Xidel. A tool to query data from anything on the web and extract what you want
-
How to make http request with curl on certain page after being authenticated?
I built Xidel for such authenticated requests:
What are some alternatives?
Mage - 🧙 The modern replacement for Airflow. Mage is an open-source data pipeline tool for transforming and integrating data. https://github.com/mage-ai/mage-ai
jq - Command-line JSON processor [Moved to: https://github.com/jqlang/jq]
quadratic - Quadratic | Data Science Spreadsheet with Python & SQL
tools - all-in collection of productivity scripts, CLI tools, utility libraries, fuse filesystems, and also some stuff
astro - Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow. [Moved to: https://github.com/astronomer/astro-sdk]
pup - Parsing HTML at the command line
starthinker - Reference framework for building data workflows provided by Google. Accelerates authentication, logging, scheduling, and deployment of solutions using GCP. To borrow a tagline.. "The framework for professionals with deadlines."
gron - Make JSON greppable!
astronomer-cosmos - Run your dbt Core projects as Apache Airflow DAGs and Task Groups with a few lines of code
yq - Command-line YAML, XML, TOML processor - jq wrapper for YAML/XML/TOML documents
awesome-pipeline - A curated list of awesome pipeline toolkits inspired by Awesome Sysadmin
xmltodict - Python module that makes working with XML feel like you are working with JSON