以下是一个使用BigQuery和Firebase Analytics进行数据分析的示例代码：

1. 安装和配置BigQuery SDK

pip install google-cloud-bigquery

2. 使用Firebase Analytics导出数据到BigQuery

from google.cloud import bigquery

project_id = 'your-project-id'
dataset_id = 'your-dataset-id'
table_id = 'your-table-id'
bucket_name = 'your-bucket-name'

client = bigquery.Client(project=project_id)
dataset_ref = client.dataset(dataset_id)
table_ref = dataset_ref.table(table_id)

job_config = bigquery.LoadJobConfig()
job_config.source_format = bigquery.SourceFormat.NEWLINE_DELIMITED_JSON
job_config.write_disposition = bigquery.WriteDisposition.WRITE_TRUNCATE

uri = f'gs://{bucket_name}/path/to/exported/data.json'

load_job = client.load_table_from_uri(
    uri, table_ref, job_config=job_config
)
load_job.result()

3. 查询Firebase Analytics数据

query = """
SELECT
    event_date,
    event_name,
    COUNT(*) as event_count
FROM
    `your-project-id.your-dataset-id.your-table-id`
WHERE
    event_name = 'your-event-name'
GROUP BY
    event_date, event_name
ORDER BY
    event_date
"""

query_job = client.query(query)
results = query_job.result()

for row in results:
    print(f'{row.event_date}: {row.event_name} - {row.event_count}')

以下是一个使用BigQuery和Firebase Crashlytics进行错误分析的示例代码：

1. 安装和配置BigQuery SDK

pip install google-cloud-bigquery

2. 使用Firebase Crashlytics导出数据到BigQuery

from google.cloud import bigquery

project_id = 'your-project-id'
dataset_id = 'your-dataset-id'
table_id = 'your-table-id'
bucket_name = 'your-bucket-name'

client = bigquery.Client(project=project_id)
dataset_ref = client.dataset(dataset_id)
table_ref = dataset_ref.table(table_id)

job_config = bigquery.LoadJobConfig()
job_config.source_format = bigquery.SourceFormat.NEWLINE_DELIMITED_JSON
job_config.write_disposition = bigquery.WriteDisposition.WRITE_TRUNCATE

uri = f'gs://{bucket_name}/path/to/exported/data.json'

load_job = client.load_table_from_uri(
    uri, table_ref, job_config=job_config
)
load_job.result()

3. 查询Firebase Crashlytics数据

query = """
SELECT
    event_date,
    event_name,
    COUNT(*) as event_count
FROM
    `your-project-id.your-dataset-id.your-table-id`
WHERE
    event_name = 'your-event-name'
GROUP BY
    event_date, event_name
ORDER BY
    event_date
"""

query_job = client.query(query)
results = query_job.result()

for row in results:
    print(f'{row.event_date}: {row.event_name} - {row.event_count}')

希望这个示例代码可以帮助你进行BigQuery和Firebase Analytics以及Firebase Crashlytics的数据分析。请根据你自己的项目和需求进行相应的修改。