SmileAfterBurn
Community@SmileAfterBurn · Ukraine
Засновник проєкту SmileAfterBurn. Пройшовши через складну травму, вигорання та тривалий шлях відновлення, я присвятив себе цифровізації соціальної сфери України
Agent Skills by SmileAfterBurn
Showing 29 vetted skills indexed across 1 GitHub repositories.
SmileAfterBurngcp-data-pipelines
Routes data pipeline requests to the appropriate Google Cloud tool skill.
SmileAfterBurndiscovering-gcp-data-assets
Discovers and inspects Google Cloud data assets using Dataplex search and context lookup.
SmileAfterBurngcp-spark
Generates and executes Spark code on Google Cloud Dataproc clusters and serverless batches.
SmileAfterBurnmanaging-python-dependencies
Detects project dependency managers and installs Python packages with the correct tooling.
SmileAfterBurndata-autocleaning
Profiles and cleans BigQuery and GCS data using Dataplex scans and SQL transformations.
SmileAfterBurngcp-dataflow
Guides authoring, packaging, launching, and diagnosing Apache Beam pipelines on Google Cloud Dataflow.
SmileAfterBurnbigquery-data-transfer-service
Discovers and inspects BigQuery Data Transfer Service configurations for data ingestion pipelines.
SmileAfterBurnenforcing-resource-attribution
Applies attribution labels to bq and gcloud CLI commands for resource tracking.
SmileAfterBurnbigquery-bigframes
Generates Python code using BigQuery DataFrames for pandas-style analysis and ML on BigQuery.
SmileAfterBurndbt-bigquery
Generates, modifies, and optimizes dbt models and pipelines targeting Google BigQuery.
SmileAfterBurngcp-composer-troubleshooting
Diagnoses failed Cloud Composer DAGs using gcloud logs and remote code to generate RCA reports.
SmileAfterBurnbigquery-graph
Generates GQL queries and property graph DDL for BigQuery graph analytics.
SmileAfterBurnfederate-lakehouse-catalog
Configures Google Cloud Lakehouse federated catalogs connecting BigQuery to Databricks Unity and AWS Glue.
SmileAfterBurnaccidental-data-loss-prevention
Blocks irreversible deletion commands until explicit user consent is obtained.
SmileAfterBurnbuilding-data-apps
Build data dashboards and interactive reports with React, Vite, or Streamlit on GCP data sources.
SmileAfterBurndataform-bigquery
Generates and validates Dataform SQLX pipeline code for BigQuery ELT workflows.
SmileAfterBurngcp-managed-airflow-recommendations
Diagnose Cloud Composer environments and generate evidence-based Airflow tuning recommendations from monitoring metrics.
SmileAfterBurnskill-repair
Repairs failed agent skill installations and updates manifest.json status entries.
SmileAfterBurngcp-managed-airflow-dag-authoring
Author and validate Apache Airflow DAGs for Google Cloud Managed Airflow environments.
SmileAfterBurngoogle-cloud-storage-basics
Manages Google Cloud Storage buckets and objects via CLI, APIs, and client libraries.
SmileAfterBurnbigquery-ai-ml
Write BigQuery SQL queries using AI functions for forecasting, anomaly detection, and text generation.
SmileAfterBurngcp-pipeline-orchestration
Generates, validates, deploys, and triggers Google Cloud Composer orchestration pipeline definitions.
SmileAfterBurngcloud-auth-verification
Diagnose and resolve Google Cloud authentication and Application Default Credentials errors.
SmileAfterBurnnotebook-guidance
Guides creation and execution of Jupyter notebooks for BigQuery data analysis and visualization.
Frequently Asked Questions About SmileAfterBurn
FAQPage SchemaWhat tasks can I accomplish using SmileAfterBurn's registered skills?▼
You can build and orchestrate Google Cloud data pipelines using dbt, Dataform, Dataflow (Apache Beam), Spark on Dataproc, and Cloud Composer. Skills also cover BigQuery SQL optimization, BigFrames dataframes, GCS bucket management, lakehouse federation to Databricks Unity or AWS Glue, data cleaning, and security assessments.
Who are these skills designed for?▼
Data engineers, analytics engineers, and platform teams working on Google Cloud. They suit practitioners writing BigQuery SQL, authoring Airflow DAGs, managing Spark or Beam ETL jobs, configuring DTS ingestion, and enforcing governance such as resource labeling and accidental data loss prevention.
How do the pipeline orchestration skills work in practice?▼
The gcp-pipeline-orchestration skill generates or updates Cloud Composer orchestration definitions for dbt, notebooks, Spark, Dataform, and BigQuery SQL, then deploys and triggers them. Companion skills handle DAG authoring, Airflow 2-to-3 migrations, environment tuning, and RCA reports for failed DAGs.
Are these skills free and open source?▼
Yes. Every skill in the manifest is published under the Apache-2.0 license by publisher 'google', permitting free use, modification, and redistribution. There is no licensing cost; you only pay for the underlying Google Cloud resources (BigQuery, Dataflow, Composer, GCS) you consume.
What prerequisites and dependencies are required?▼
You need a Google Cloud project with authenticated gcloud/bq credentials or Application Default Credentials (the gcloud-auth-verification skill resolves auth errors). Python work requires project-scoped virtual environments per the managing-python-dependencies skill, and notebooks use %%bqsql magics rather than the BigQuery client library.