Integrating infrastructure data into data warehouses is a complex task for Platform Teams, often hindered by multiple API endpoints, authentication challenges, and inconsistent data formats across cloud providers. The tap-pulumi-cloud connector addresses these issues by automating the process of accessing infrastructure data, utilizing Pulumi Cloud data to avoid custom API integrations and ensuring data consistency. This connector transforms raw data into a structured format ready for analysis, reducing time spent on data wrangling and allowing for quicker insight generation. Built on the Meltano SDK, tap-pulumi-cloud supports various data loaders, enabling seamless data integration into data warehouses like Snowflake, BigQuery, Redshift, or Postgres. It facilitates the creation of analytics such as average resources under management, deployment times, user updates, and can integrate with CI/CD and cost data for comprehensive reporting. The setup process involves installing Meltano, configuring the connector, and running data pipelines, with options for regular orchestration using tools like Airflow or Docker. The system supports upserting data by default, but can be configured to insert new data only, making it adaptable for historical data tracking or current status monitoring.