HI community, I'm satrting to use meltano to extra...
# troubleshootinga
AMR
03/05/2024, 9:24 PMHI community, I'm satrting to use meltano to extrat data from many sources but I still have problems with the setup on windows 11 any idea and best practice please?
e
Edgar Ramírez (Arch.dev)
03/05/2024, 9:32 PMHi @AMR 👋
I'm not on Windows, but what problems are you having with the setup?
Edgar Ramírez (Arch.dev)
03/05/2024, 9:33 PMAlso, https://docs.meltano.com/guide/installation-guide/#windows might be a good start if you haven't read it yet
a
AMR
03/05/2024, 9:37 PMHI @Edgar Ramírez (Arch.dev) thank you for your help,
I'm working on many separeted python spaces as a data eng using anaconda
so I create a new conda env with python 3.9 and I try to install meltano using pip and pipx
after that I create meltano project but in the step of adding an extractor I have many probs
for exp :
Copy code
$ meltano add extractor tap-zoho-crm
2024-03-05T21:32:14.984741Z [warning ] Failed to create symlink to 'meltano.exe': administrator privilege required
2024-03-05T21:32:17.947075Z [warning ] `kind: password` is deprecated for setting definitions in favour of `sensitive: true`, and is currently in use by the following settings of extractor 'tap-zoho-crm': 'airbyte_config.client_id', 'airbyte_config.client_secret', 'airbyte_config.refresh_token'. Please open an issue or pull request to update the plugin definition on Meltano Hub at <https://github.com/meltano/hub/blob/main/_data/meltano/extractors/tap-zoho-crm/airbyte.yml>.
Added extractor 'tap-zoho-crm' to your project
Variant: airbyte (default)
Repository: <https://github.com/airbytehq/airbyte/tree/master/airbyte-integrations/connectors/source-zoho-crm>
Documentation: <https://hub.meltano.com/extractors/tap-zoho-crm--airbyte>
Installing extractor 'tap-zoho-crm'...
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.
'unicodeescape' codec can't decode bytes in position 257-258: truncated \uXXXX escapeAMR
03/05/2024, 9:38 PMthnx in advance
AMR
03/05/2024, 9:54 PMalso after installing meltano using pipx I have this problem when taping
meltano --versionAMR
03/05/2024, 9:54 PM Copy code
$ meltano --version
╭─────────────────────────────── Traceback (most recent call last) ────────────────────────────────╮
│ in _run_module_as_main:198 │
│ in _run_code:88 │
│ │
│ in <module>:4 │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\cli\__init__.py:10 in <module> │
│ │
│ 7 import sys │
│ 8 import typing as t │
│ 9 │
│ ❱ 10 from meltano.cli import ( # noqa: WPS235 │
│ 11 │ add, │
│ 12 │ config, │
│ 13 │ docs, │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\cli\add.py:12 in <module> │
│ │
│ 9 import click │
│ 10 import requests │
│ 11 │
│ ❱ 12 from meltano.cli.params import pass_project │
│ 13 from meltano.cli.utils import ( │
│ 14 │ CliError, │
│ 15 │ PartialInstrumentedCmd, │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\cli\params.py:9 in <module> │
│ │
│ 6 │
│ 7 import click │
│ 8 │
│ ❱ 9 from meltano.cli.utils import CliError │
│ 10 from meltano.core.db import project_engine │
│ 11 from meltano.core.migration_service import MigrationError │
│ 12 from meltano.core.project_settings_service import ProjectSettingsService │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\cli\utils.py:18 in <module> │
│ │
│ 15 │
│ 16 from meltano.core.error import MeltanoConfigurationError │
│ 17 from meltano.core.logging import setup_logging │
│ ❱ 18 from meltano.core.plugin.base import PluginDefinition, PluginType │
│ 19 from meltano.core.plugin.error import InvalidPluginDefinitionError, PluginNotFoundError │
│ 20 from meltano.core.plugin_install_service import ( │
│ 21 │ PluginInstallReason, │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\core\plugin\__init__.py:3 in │
│ <module> │
│ │
│ 1 from __future__ import annotations │
│ 2 │
│ ❱ 3 from .base import ( │
│ 4 │ BasePlugin, │
│ 5 │ PluginDefinition, │
│ 6 │ PluginRef, │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\core\plugin\base.py:14 in │
│ <module> │
│ │
│ 11 from meltano.core.behavior import NameEq │
│ 12 from meltano.core.behavior.canonical import Canonical │
│ 13 from meltano.core.behavior.hookable import HookObject │
│ ❱ 14 from meltano.core.job_state import STATE_ID_COMPONENT_DELIMITER │
│ 15 from meltano.core.plugin.command import Command │
│ 16 from meltano.core.plugin.requirements import PluginRequirement │
│ 17 from meltano.core.setting_definition import SettingDefinition, SettingKind, YAMLEnum │
│ │
│ C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\meltano\core\job_state.py:8 in │
│ <module> │
│ │
│ 5 import typing as t │
│ 6 from datetime import datetime │
│ 7 │
│ ❱ 8 from sqlalchemy.orm import Mapped, Session, mapped_column │
│ 9 │
│ 10 from meltano.core.job import JobFinder, Payload │
│ 11 from meltano.core.models import SystemModel │
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯
ImportError: cannot import name 'mapped_column' from 'sqlalchemy.orm'
(C:\Users\a.ouni\AppData\Local\anaconda3\Lib\site-packages\sqlalchemy\orm\__init__.py)e
Edgar Ramírez (Arch.dev)
03/05/2024, 10:02 PMIt seems you previously installed meltano globally with anaconda?
Edgar Ramírez (Arch.dev)
03/05/2024, 10:03 PM(and that's causing conflicts with other dependencies in that environment)
Edgar Ramírez (Arch.dev)
03/05/2024, 10:05 PMI haven't used conda in a while so I'm not sure how you manage environments, but you should install meltano into its own isolated environment
a
AMR
03/05/2024, 10:17 PMthank you for these infos
np 1
4 Views